B
Box 666
I have two tables:- "A" is preloaded with bulk data, each time relating
customer data is loaded it is given the same ref no. Table "B" is to be a
summary table linked by ref no. So (say) five items on "A" all with ref no
66 are to be sumaries on table "B" under the ref no 66. The ref no being the
join between the 2 tables.
I have created a query from "A" and "B" using all fields from both tables. I
have then based a input form on that query. However it will not let me fill
/ populate any fields from table "B"
I assume this is because "B" is empty and therefore there are no join fields
that are equal.
So how do I populate "B"
Bob
customer data is loaded it is given the same ref no. Table "B" is to be a
summary table linked by ref no. So (say) five items on "A" all with ref no
66 are to be sumaries on table "B" under the ref no 66. The ref no being the
join between the 2 tables.
I have created a query from "A" and "B" using all fields from both tables. I
have then based a input form on that query. However it will not let me fill
/ populate any fields from table "B"
I assume this is because "B" is empty and therefore there are no join fields
that are equal.
So how do I populate "B"
Bob