L
Lojaine
Guest
Hi guys...
I started a new job and i hv been asked to develop a small system for a travel agency..
the CASE is .. i hv such theory
Supplier has 1/alot of reservations and each reservation would have 1/alot of hotels
when i relate the reservation to supplier it works perfectly .. but when i relate the hotels to the reservations things get missed up .. when i tried to put another autonumber in the reservation it was rejected coz it was already in the there .. how can i set a counter or function like a= a+1 for each cel that is entered... I dunno what is needed . i just need to link those three together
and something else i need to generate a number(refrence number for the supplier) and share it with all the tables
i wiould appritiate any help offered
I started a new job and i hv been asked to develop a small system for a travel agency..
the CASE is .. i hv such theory
Supplier has 1/alot of reservations and each reservation would have 1/alot of hotels
when i relate the reservation to supplier it works perfectly .. but when i relate the hotels to the reservations things get missed up .. when i tried to put another autonumber in the reservation it was rejected coz it was already in the there .. how can i set a counter or function like a= a+1 for each cel that is entered... I dunno what is needed . i just need to link those three together
and something else i need to generate a number(refrence number for the supplier) and share it with all the tables
i wiould appritiate any help offered