A
Aardvark
I have a client table which clientID is an autonumber, primary key and an
invoice table in which ClientID is a number field, with invoice number as a
foreign key. So far so good, however if I enter a new invoice presumably I
have to type the custoemr number into my invoice table (since otherwise how
will the pc know who has what invoice). If this is correct though it seems
far from ideal as I would need an encyclopaedic memory to recall who has
what customer ID. Any thoughts most welcome
invoice table in which ClientID is a number field, with invoice number as a
foreign key. So far so good, however if I enter a new invoice presumably I
have to type the custoemr number into my invoice table (since otherwise how
will the pc know who has what invoice). If this is correct though it seems
far from ideal as I would need an encyclopaedic memory to recall who has
what customer ID. Any thoughts most welcome