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
"David S. Zuza" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> "Amy Blankenship" <(E-Mail Removed)> wrote in message
> news:eAIF%(E-Mail Removed)...
>> 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
>>
>> "David S. Zuza" <(E-Mail Removed)> wrote in message
>> news:%23Q%(E-Mail Removed)...
>>> 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
>>>
>>
>>
>
>
|
Similar Threads
