netuse@debouck.
Registered User.
- Local time
- Today, 13:00
- Joined
- Jun 27, 2004
- Messages
- 37
OK NEED HELP HELP,
i have 2 tables a table for resident vehicles and one for vehicles logged in at the gate. i have a query for the gate log tha gives me vehicle plate and with another table guest name and location to where they are going. i have another query for resident vehicles that gives me vehicle info resident name from a resident table and location from a location table all linked by loc#. i have a search form for plate input that opens a form to view relavant info using a union query of the above 2. problem is it can be very slow is there a better way to do this? any help would be appreciated.
i have 2 tables a table for resident vehicles and one for vehicles logged in at the gate. i have a query for the gate log tha gives me vehicle plate and with another table guest name and location to where they are going. i have another query for resident vehicles that gives me vehicle info resident name from a resident table and location from a location table all linked by loc#. i have a search form for plate input that opens a form to view relavant info using a union query of the above 2. problem is it can be very slow is there a better way to do this? any help would be appreciated.
