How to list several fields from different tables in a form?
Posted on 2011-02-25
I'm trying to create a quick application in Access where I can easily see the tasks I have pending but instead of a report, I want to use a form so I can interact with it.
I have a table with some very basic information from each client and other table with the activities I do with each one (send a quote, send a tool, sign a contract, etc.) each one having its own date and all. In a form I can easily see those tasks in a sub-form but I would also like to have a main form (or parent form) where I can easily see a list of clients with their current status (that is saved in the activities list) so I can quickly see the pending tasks.
As I said, I could easily list them in a report but I would like to be able to click on a button (or click on one of the clients) and opena new form with the information and activities for that client so I can modify it.
So far I've been able to create a query that will merge the fileds I need from both tables but they are shown table style... I want to put buttons and actions into it. Can it be done?