Data Access Page design problem

D

Debi Grafton

I am trying to design a Data Access Page in Access 2000. What I want is a page that will show a drop-down list of Job Names and when you select a job from the drop-down list, you will get a list of all Vendors used on that job and then a list of all that vendor’s invoices for that job. It would also be wonderful if the Invoice field could be a hyperlink to a scanned image of the actual invoice. It is very similar to the “Review Orders†Data Access Page in the Northwind sample database from Microsoft. I have several tables and queries that hold the information I need, but I am not sure if I need to use the fields (Job Name, Vendor, Invoice) from the same table or from different tables or queries.

Any help would be greatly appreciated as I’ve spent lots of wasted hours on this project already.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Create a macro to change a value in a record 1
Automatically enter values in fields in a table 1
Multi user settings 3
Run-time error '3075' 10
Connect to sub-form without Parent/Child link 3
Pie Chart and Table Query 2
Database design many to many relationships 4

Top