Need Access help.

[Diasflac]

I haven't done anything like this for 10 years and it seems to all be forgotten:




I will tell you what I have at the moment:

5 tables.

Supplier (Supplier Number, Supplier Name, Currency, Payment Terms, Contact Person, Contact Number and Supplier address)


Inco Terms (Inco terms, Inco terms description)


R&D (Name, Telephone number, Email address, Office Address)


Requestor (Name, Contact Number, Department, E-mail address, Job title, office address, WA or CP?)


RFQ (RFQ Reference number, RFQ Title, RFQ Date, Supplier Name, Requestor, RFQ Deadline, R&D Engineer Responsible, Inco Terms, Validity of Prices, Currency, Exchange rate, Opt out date, Date Response received, attackments).


I have 1 Form


Basically the user fills in fields of the RFQ table either typing in or matching details from the other tables and they save which generates a new reference number and saves the record.


What I also have is another button for "Print". I want this to fill in certain fields in an already created Word template. I have used mail-merge to do this however it only lets me select 1 table but some of the information I need is in other tables but needs to be looked up from fields in the RFQ table. I have linked the fields in each table via relationship yet they're not giving me the option to select them.


For example, I have the RFQ field Requestor which is the name of the requestor. I link this with the requestor table but in the Word Template I need the job title, address and telephone number looked up from that 1 record in the RFQ table.


Can anyone offer any assistance or point me in the right direction. I've read a general guide but it doesn't answer my query, a more specific guide would be a help in this case.

[June7]

As far as I know, mail merge should be able to work with query dataset. What I have found that doesn't work are calculated fields in queries. All data for the merge must be native fields and that means including related tables in the query. http://office.microsoft.com/en-us/ac...001233657.aspx

Do you really need mail merge? Why not an Access report?