Enter 1 field, then multiple field then auto fill !!! Help !!! Brain melting

I am a newbie to zoho, but I am a quick learner. I have learned about pick list, and auto fill. Example , I pick a state, and then in my city drop down, it will only show me cities in that state. I think its called a pick list, But its only one to one.. I pick a state , then it gives me cities .. i need something that will allow me to input one item,, and have auto fill of multiple fields..

My goal is this.

i want to be able to import, records that contain [store id, address, city, state, zip] in separate fields.

I want a customer to be able to fill in their name and then
select the stores id number.. that will then fill in multiple field [store id, address, city, state, zip]

When i export the record to excel.. in one line of data, in separate columns .. the customers name, store id, address, city, state, zip..

The idea is to have the customer just have to give name and store id, but when i export the data i need results in multiple fields \ columns.

Any help would be appreciated...