Auto Add

  • Thread starter Thread starter David S. Zuza
  • Start date Start date
D

David S. Zuza

Hey all,

This might be stupid but here it goes.

I have 2 tables. 1 with Personnel Information and 1 with Company information
ie

Table 1: Personnel
Fname: Text
Lname: Text
Store_From_Number
Store_From_Address
Store_From_City
Store_From_State
Store_From_Zip

Table 2: Store_Info
Store_Number
Store_Address
Store_City
Store_State
Store_Zip

What I am trying to do is type in the store number and and have all of the
store information be added to the personnel record. I would like to have a
drop down that I can slect the store number and after selection it add it to
the current personnel record. Can I do this without code or do I need to go
there. And if so How?


Dave
 
What you want is not to add all the store info to the personnel table, but
to use a foreign key from the Store_info table in the Personnel table to
refer to all the data that exists (only ONCE) in the store_info table.

You should read up on data normalization.

HTH;

Amy
 
Yeah,
I thought about that but the guy I am writting this for wants it the
other way. I gotta be honest I over simplified my requirements Because I
will have two seperate groups of Store information in the Personnel Table,
there will be a From_Store_Address... and a To_Store_Address data in the
personnel table and the information will be pulled from the same store
information Table.

I think I explained that well..if not let me know and I will try to do a
better job.

thanx for any help
Dave
 
Your customer should not care about the table structure itself if you create
forms, reports, and queries that do what are needed. The end user should
never even see the tables. It's very easy to just insert the from and to
foreign keys into the personnel table.

However, it sounds like you're probably better off with a PersonnelStore
table and then have a "Type" field which for now would be either to or from
but ultimately might have other values.

I'm not going to give you advice that will lead to an unmaintainable
database. That would not be serving you or your client well. If you're
insistent, you may want to try reposting your question. Bear in mind that
it's likely you'll get the same advice from others.

Good luck!

-Amy
 
Back
Top