RELATIONSHIP & QUERIES

W

Windseaker

QUESTION .

First I will enter info into TBL Radio Receipt, from there I want the
information to jump to TBL Radio Info and prompt me to complete this table.
Then it will jump to either TBL New Radio Information OR TBL Repair
Information. This will need to be completed. How does this happen, I mean--
How do I create the relationships to reflect this path? I tryed making a one
to many but it will not assocate.

PS I have a snap shot of problem
 
J

Jeanette Cunningham

Hi,
Not sure what information you have for your radio repair business, here is a
starting idea for 2 tables.
tblRadios is related One to Many to tblRepairs.
One radio can be repaired many times.

tblRadios ...
RadioID >Primary Key
DateReceived
ReceiptNo
Model
OtherInfo


tblRepairs ...
RepairID >Primary Key
RadioID >Foreign Key from tblRadios
RepairDate
Repair Info

Jeanette Cunningham
 
Top