F
faffy
i have 2 tables called master and venues. the master table contains a field
called address and the venue table also has a field named address. i need a
way of bringing the contents of the address field in the venues table into
my master form field called address, based upon a unique venue id. i can do
this ok but i also need to be able to type directly into the address field of
the master form for one off venue addresses without having to create a new
record in the venues table.
i know i shouldn't duplicate data in this way but i have other reasons for
wanting to design the database this way.
can anyone help please.
called address and the venue table also has a field named address. i need a
way of bringing the contents of the address field in the venues table into
my master form field called address, based upon a unique venue id. i can do
this ok but i also need to be able to type directly into the address field of
the master form for one off venue addresses without having to create a new
record in the venues table.
i know i shouldn't duplicate data in this way but i have other reasons for
wanting to design the database this way.
can anyone help please.