A
Ann
is it possible to query 2 tables where there is a common field but the data
in the field from one table might only partially equal the same field in the
other table or can you have a data field in a form where you can enter more
than one entry and then match it with another table via query that only uses
one of those entries?
For example:
I have a table for billing info that has more than one lot number for a
particular bill. I also have a different table with inventory info with one
specific lot number. I want to query both tables by specifying a lot number
so I can see the billing info and the inventory info for a certain lot number.
in the field from one table might only partially equal the same field in the
other table or can you have a data field in a form where you can enter more
than one entry and then match it with another table via query that only uses
one of those entries?
For example:
I have a table for billing info that has more than one lot number for a
particular bill. I also have a different table with inventory info with one
specific lot number. I want to query both tables by specifying a lot number
so I can see the billing info and the inventory info for a certain lot number.