Inexperienced access user trying to get an understanding of school access project

[dvince86]

Hi all,



I have been asked to help a friend with an access database issue as they are stumped, but if I'm honest my knowledge is no better.

The project is for a mock piece of work in a school where they are making a database for a car sales company.

They have made different queries and forms to allow them to navigate between customers and cars for sale ect.

The final aspect is to make it possible to purchase a car.

The user needs to be able to select a car (which is held in available_cars_table) and then select a customer (held in customers_table) and input that information into a 3rd table that will hold the purchased cars therefore showing which customer purchased the car, the car in 'available_cars_table' is then deleted as it is no longer available to be purchased.

I have no idea where to start with this as I am not experience in this so reaching out to the community for help.

Any assistance would be greatly appreciated

Thanks in advance

[moke123]

cross-posted https://www.access-programmers.co.uk...roject.317808/

[ranman256]

needed:
tCars table
tCustomer table

tCustCars table to hold their purchases
ID (autonum)
CustID* (long)
VIN*
PurchDate
...etc.

[CJ_London]

No need to delete the record from the car table - you can exclude them from the available list because a record exists in the sold table. Use a left join query