G
GrahamT
So, Franze. Basically you are telling us that you need a Many-to-Man
relationship between your Supplier table & your Calls table
To do this, you must create an extra table - lets call i
'CallsToSuppliers' table. This table has 2 fields: SupplierID an
CallID, each being of Long Integer data type. In Table Design view
highlight both felds and create a combined Primry Key. Then, lin
each of these fields to their corresponding fields in your Supplie
table & Calls table
One other point I query: you say that one call can embody man
Transactions, but can one Transaction be covered by many calls? I
so, then you will need another Many-to-Many relationship between you
Transactions table & your Calls table (call i
'CallsForTransactons', perhaps). Create it in the same way as th
'CallsToSuppliers' table
Cheers, & I hope this helps
Graham
relationship between your Supplier table & your Calls table
To do this, you must create an extra table - lets call i
'CallsToSuppliers' table. This table has 2 fields: SupplierID an
CallID, each being of Long Integer data type. In Table Design view
highlight both felds and create a combined Primry Key. Then, lin
each of these fields to their corresponding fields in your Supplie
table & Calls table
One other point I query: you say that one call can embody man
Transactions, but can one Transaction be covered by many calls? I
so, then you will need another Many-to-Many relationship between you
Transactions table & your Calls table (call i
'CallsForTransactons', perhaps). Create it in the same way as th
'CallsToSuppliers' table
Cheers, & I hope this helps
Graham