K
K Dales
It sounds like the freight cost, pallet charge, and other
expenses are NOT current fields in the linked table, am I
correct? If so, the best thing to do is not a make table
query - because then any time you run that query it will
delete any existing data and make a new table. Instead,
it seems to me it is best to create a new table with the
fields you desire and a "linking" field that points to the
primary key of the linked table. For example, your new
table might have the fields PO_NUMBER, FREIGHT_COST,
PALLET_CHARGE, OTHER_EXPENSES. Join the two tables in the
query design (a one-to-one join, I think) and build your
input form off this query.
information from the linked table which i do throiugh the
query. In addition on the form i want to have a user
enter field to add information fro freight cost, pallet
charge, and other expenses. Is the best way to do this
through a make table query.
expenses are NOT current fields in the linked table, am I
correct? If so, the best thing to do is not a make table
query - because then any time you run that query it will
delete any existing data and make a new table. Instead,
it seems to me it is best to create a new table with the
fields you desire and a "linking" field that points to the
primary key of the linked table. For example, your new
table might have the fields PO_NUMBER, FREIGHT_COST,
PALLET_CHARGE, OTHER_EXPENSES. Join the two tables in the
query design (a one-to-one join, I think) and build your
input form off this query.
received, and cost. I wat to be able to pull this
information from the linked table which i do throiugh the
query. In addition on the form i want to have a user
enter field to add information fro freight cost, pallet
charge, and other expenses. Is the best way to do this
through a make table query.