Obviously, I am new to access, but have a decent understanding of VBA.
I have a remote, one to many, ticket db that i use a make-table query, to retreive all relevant information so I only have to query the remote db once. This creates table "A" locally. Each note has an individual record, so I created a form to get unique ticket numbers based on a query of table "A". Then I created a subform that keys off ticket id, queries table "A" for the notes, and returns the notes for the ticketid a person views in the form. Now the person scans through the ticket, and decides if it is relevant or not, if it is, they hit a button on the form that adds the ticket id to a permanent table "B" First off, since this is my first time messing with a db, is there an easier way to perform what I just explained? And my second question is:
When the user views the ticket in the form based on a query of table "A", I want to search for the ticket id in table "B" to determine if it already exists, if it does, I want to display a label that says "Ticket exists" so:
if ticket id exists in table "B" then label1=visible
I figure the second part should be fairly easy, but have racked my brain too much tonight I guess :wink: Thanks for you help!
I have a remote, one to many, ticket db that i use a make-table query, to retreive all relevant information so I only have to query the remote db once. This creates table "A" locally. Each note has an individual record, so I created a form to get unique ticket numbers based on a query of table "A". Then I created a subform that keys off ticket id, queries table "A" for the notes, and returns the notes for the ticketid a person views in the form. Now the person scans through the ticket, and decides if it is relevant or not, if it is, they hit a button on the form that adds the ticket id to a permanent table "B" First off, since this is my first time messing with a db, is there an easier way to perform what I just explained? And my second question is:
When the user views the ticket in the form based on a query of table "A", I want to search for the ticket id in table "B" to determine if it already exists, if it does, I want to display a label that says "Ticket exists" so:
if ticket id exists in table "B" then label1=visible
I figure the second part should be fairly easy, but have racked my brain too much tonight I guess :wink: Thanks for you help!