Help with Airport Transfer Database

[grantty]

Hi All,



This is my first time using Access and i'm trying to make a airport transfer database for a family member. I have 3 tables Journeys,Drivers and Customers.All relationships are assigned and i've created forms for outbound and inbound journeys (all data is on one Journey table however). The problem I am having is that because outbound and inbound are all in the Journey table, once you assign a driver to the journey the driver is assigned to both outbound and inbound journeys (this however isnt always the case for the company). To fix it my best guess is that I will need to split the Journeys table into outbound and inbound tables, however I don't want 2 separate journeyIDs (primary key). Is there a way of connecting the two tables so that if I create an outbound journey it will have ID 1 then if it has a inbound journey this will have ID 2 (not 1 again becuase its the first inbound). Then the next booking made (on the outbound journey) will automatically have ID 3 (and not 2 because its the second outbound journey).

I hope i've explained it well enough and if you think im doing it completely the wrong way all advice would great thanks.

[chaddresnick]

If you want consecutive ID numbers for Journeys, you need them in one table. With that said, why can't ID 1 be outbound journey and then ID 2 be inbound. Just create a field so you know if a journey is outbound or inbound. This also would help with one-way travel.