Hello,
I am trying to achieve the following.
Table 01
Name
Surname
Invoice Number
Table 02
Data 01 (product name)
Data 02 (product weight)
Data 03 (product size)
What i need to do is the following...
One invoice can have more than one products on it, thus, more than one rows off DATA 1 / DATA 2 / DATA 3.
So what i need to do is create the correct relationships so that, i can create a form that will accept a name/surname/invoice number and then the field data1/data2/data3 multiple times.
And then to print via reports the invoice and all the corresponding product rows for that particular invoice.
CAN SOMEONE PLEASE HELP.
Thank you.