By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Displaying information from multiple tables on a form

P: 1
I've got a large database that has many different tables (people, vehicles, incidents, citations, calls). The database is used to keep track of certain information for my department.

I've got a table for vehicles, which stores information on vehicles such as make, model, color, year, license plate, etc. I've got another table for citations which displays date, violations, officer, license plate, name, etc.

If someone pulls up a certain vehicles information using the Vehicle Information form it would have a tab called Citations which I'd like to show all of the citations that were issued to that license plate and have a button that can be clicked to view the citation information.

How would I go about doing this?

The citation information could be loaded when the vehicle form is opened, or when the citations tab is selected, or have a button that says get citations.

The vehicles form:


(a tab called "Citations" next to "Incidents" will show all citations issued to the vehicle with the license plate number of the vehicle being viewed)
Jul 24 '18 #1
Share this Question
Share on Google+
2 Replies


zmbd
Expert Mod 5K+
P: 5,287
Forgive the numbers :) it's quite late, and this helps me keep my thoughts straight...

1) If you want to keep this information on the form then take a look at the database I've attached here: https://bytes.com/topic/access/answe...es#post3817727
You'll most likely need to use a similar subform to the one I have in the database in the tab-control-page1.

2) Option two is a pop-up form triggered by a command button on your form. The pop-up could then show the details.

3) please don't use external image sites
[IMG]https://i.imgur.com/Flf4PYg.png[/IMG]
Instead, use the [Advanced] button below the "Post Your Reply" box and directly upload the image into the thread using the manage attachments tool.
Many of us do this from work and image sites such as imgur.com are blocked by company firewalls (I happen to be at home or I wouldn't be able to see your image :) )

4) Appears that you have the right nomenclature.
Bound form using a tab-control with three pages named "General," "Incidents," and "Notes".
Jul 24 '18 #2

PhilOfWalton
Expert 100+
P: 1,430
Is there only one citation per incident, or can there be multiple citations per incident?

In the former case, assuming the linking field is Licence plate then an addition Citations page with a linked continuous subform showing all the citations for that Licence plate.

If the later situation is true, assuming that the incidents are on a continuous subform, the Citation subform needs to have the link set to Licence Plate and Incident. On the after update of the incident, you need to refresh the Citation subform.

If you need any more help, please come back

Phil
Jul 24 '18 #3

Post your reply

Sign in to post your reply or Sign up for a free account.