N
need help
Hi All
I want to join two tables.
I have a table [Freight Detail] table where I use forms to enter details of
freight (cartons, pallets etc). I have also created another table [Freight
Invoice] where I want to record the details of the invoice from Transport
Company that I receive later (which has not data at the moment).
[Freight Details] [Freight Invoice]
freight invoice freight invoice
cartons invoice #
pallets invoice date
con note (main reference)etc
cost etc
etc
What I want to do is to be able to relate these two table so that I can make
Freight Detail table subform of Freight Invoice. So when I get a transport co
invoice, I want to be able to pull up all the related data from a Freight
Detail table and apply the costs.
I am having trouble because I enter the [Freight Detail] first and the
[Freight Invoice] later (when I receive the actual invoice). So there is
already data in the [Freight Detial] table but nothing in the [Freight
Invoice].
One [Freight Invoice] can have multiple connote
It almost seems like a one-to-may relationship in the reverse
I want to join two tables.
I have a table [Freight Detail] table where I use forms to enter details of
freight (cartons, pallets etc). I have also created another table [Freight
Invoice] where I want to record the details of the invoice from Transport
Company that I receive later (which has not data at the moment).
[Freight Details] [Freight Invoice]
freight invoice freight invoice
cartons invoice #
pallets invoice date
con note (main reference)etc
cost etc
etc
What I want to do is to be able to relate these two table so that I can make
Freight Detail table subform of Freight Invoice. So when I get a transport co
invoice, I want to be able to pull up all the related data from a Freight
Detail table and apply the costs.
I am having trouble because I enter the [Freight Detail] first and the
[Freight Invoice] later (when I receive the actual invoice). So there is
already data in the [Freight Detial] table but nothing in the [Freight
Invoice].
One [Freight Invoice] can have multiple connote
It almost seems like a one-to-may relationship in the reverse