Working with two tables
I have an application that allows users to create Field Tickets for work in their area. I have two tables in the application that are used to keep track of the Field Tickets. The first table contains a list of all of the blank Field Tickets called "Field Ticket Stock" that our company has had printed. The second table is the record of Field Tickets that are in use camed "Tickets". We want to track all of our tickets from the initial order of blank tickets through the the payment of the Field Ticket. The original design did not include the tracking of the field ticket from the initial purchase to the point where it was sitting in a remote office waiting to be assigned to a person who was expected to record the work done by that person. I know that the world is trying to go paperless but we are not there yet so this is the system we have to work with. We want to ensure every Field ticket that we purchase is used by our field personnel and then billed to our customers. My question is what is the method that should be used to verify the Field Ticket being assigned to a field person is actually listed in the Field Tickets Stock table before a clerk is allowed to use the field ticket number that was entered before she can save the Field ticked she has created on her side? "My thought was to run a query to verify the existence of the Field Ticket Number from the "Tickets" table in the "Field Ticket Stock" Field Ticket Number Field. ------------------------------ Paul Guillory ------------------------------Working with two tables
I have two tables which The following lists show the table names in Bold and then some of of the fields in the tables listed below the table names. I am trying to ensure that a ticket entered in the Tickets table to record work being done is a valid ticket that has been shipped to a location in the Field Ticket Stock Table before the ticket can be saved in the Tickets table. I have been trying variations of the table to table relationships so I can try to do a search of the Field Ticket Stock Table to see if the Ticket # from the Tickets table exists otherwise the user will be given a message that the Ticket # cannot be used. I have been unable to make this happen and am looking for suggestions on how to make it work. Field Ticket Stock Table Tickets T# Ticket # FT# Field Ticket # Type of Work Location Date Shipped to Location TOW Location Location Who Shipped. Date of Service (this table has 233 fields) ------------------------------ Paul Guillory ------------------------------
Form Field Display
Hello Seattle Group: I am having some confusing formatting issues. Instead of displaying the content of a name or identifier field, my form shows the record ID. When I look at the format of my Look-up Table it seems correct. The first field is the name I want displayed. Any ideas what I am doing wrong? Any assist would be greatly appreciated. Dirk ------------------------------ Dirk Ruana ------------------------------
