With a subform is it possible to reference one table but save the data to a new table?
Say i created a table (Address Table) that has my cutomers name and address in. It has 7 fields as such "customer ID, Name, Address1, Address2, Town, County, Postcode"
Now i want to create an order form. It...