Novice
Windows 7 32bit 
Access 2010 32bit
i have a table named Flight with fields: arrivalcode and fromcode, then I ought to connect to Airport table. But it make me confused since the query will take record from Airport according to field on arrivalcode and the Flight table won't connect the fromcode field with airportcode on Airport table.
please help make me clear this problem.
Indifferent
Windows 7 32bit Access 2007
What are your fields in the Airport Table? What specifically are you trying to do in your query. ie. What are your expected results. Perhaps if you gave us some sample data and your expected results.
Alan
Novice
Windows 7 32bit Access 2010 32bit
the tables are illustrated below, which ArrivalID is related to AirportID,
in case, i made a query that would show airport name based on ArrivalID and FromID. It is complicated for me because I can't connect FromID and the query only show the AirportName automatically taken from ArrivalID.
Indifferent
Windows 7 32bit Access 2007
I am not understanding. Please provide some real life data of what is in your tables and what you expect your results to look like.
Two tables with a similar field that need to be accessed simultaneously
Posting Permissions
Reply With Quote