V
VT
Hi
I have a rather conventional form and subform for booking out demo stock.
They are based on a transaction header and a transaction details table.
When demo goods are returned, they are examined by our QA guys, who issue a
uniquely numbered Goods Received Note ('GRN'). This note bears the name of
the customer returning the goods and the order ID on which they were loaned
out.
I thought the easiest way to reflect this would be to have a GRN table, with
GRN No. as a primary key. I then put this as a foreign key in the transaction
details table, since that table records every asset loaned out on every
order.
A GRN may cover all or some of the assets loaned out on a given order, since
a customer need not return all demo assets at once. A GRN never covers
multiple orders.
This 1:M relationship between the GRN table and the transaction details
table is similar to the 1:M relationship between the transaction header table
and the transaction details table. So... I'd like to enter Goods Received
information via a GRN form and a related transaction details subform but I'm
finding that difficult to implement.
Perhaps this is because a from/subform can be used to add new records, but
not to add 1:M data to existing records?
I have a rather conventional form and subform for booking out demo stock.
They are based on a transaction header and a transaction details table.
When demo goods are returned, they are examined by our QA guys, who issue a
uniquely numbered Goods Received Note ('GRN'). This note bears the name of
the customer returning the goods and the order ID on which they were loaned
out.
I thought the easiest way to reflect this would be to have a GRN table, with
GRN No. as a primary key. I then put this as a foreign key in the transaction
details table, since that table records every asset loaned out on every
order.
A GRN may cover all or some of the assets loaned out on a given order, since
a customer need not return all demo assets at once. A GRN never covers
multiple orders.
This 1:M relationship between the GRN table and the transaction details
table is similar to the 1:M relationship between the transaction header table
and the transaction details table. So... I'd like to enter Goods Received
information via a GRN form and a related transaction details subform but I'm
finding that difficult to implement.
Perhaps this is because a from/subform can be used to add new records, but
not to add 1:M data to existing records?