B
BrokenMachine
Hi there,
I'm using Access 2003 and Word 2003 and I'm trying to import data from the
word form to multiple access tables in a one to many relationship, but I
can't seem to figure it out.
I have used the following example to create a word form that transfers data
to a single access table
http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx
This seems to work fine. My problem is that I want to record several
addresses on the form rather than just one. So I have set up a second table
to record the addresses called tblAddresses and moved the fields Address,
City, State and Zip to this table. I have linked the two tables in a
one-to-many relationship with a field called ContractID.
On the Word form itself I have set up bookmarks for the first address as
fldAddress1, fldState1, fldState1, fldZip1 and Zip2.
And for the second address fldAddress2, fldState2, fldfldZip3 and fldZip4
I'm just not sure how to change the code of the module so it puts the
address data from the word form into tblAddress then adds another record for
the second address and keeps it all linked to the record in tblContracts.
Can anyone please help?
Thanks
I'm using Access 2003 and Word 2003 and I'm trying to import data from the
word form to multiple access tables in a one to many relationship, but I
can't seem to figure it out.
I have used the following example to create a word form that transfers data
to a single access table
http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx
This seems to work fine. My problem is that I want to record several
addresses on the form rather than just one. So I have set up a second table
to record the addresses called tblAddresses and moved the fields Address,
City, State and Zip to this table. I have linked the two tables in a
one-to-many relationship with a field called ContractID.
On the Word form itself I have set up bookmarks for the first address as
fldAddress1, fldState1, fldState1, fldZip1 and Zip2.
And for the second address fldAddress2, fldState2, fldfldZip3 and fldZip4
I'm just not sure how to change the code of the module so it puts the
address data from the word form into tblAddress then adds another record for
the second address and keeps it all linked to the record in tblContracts.
Can anyone please help?
Thanks