Check availability

[keri]

Hi, posting again with a more specific question.

I am trying to create a query that checks the availability of a unit
based on TBLUNITS and TBLBOOKINGS. I figured I could run a query to
show available from and to dates based on the TBLBOOKINGS, however if
the unit has no bookings at all it does not show up in my query
results.
I can understand why this is happening, TBLUNITS has a primary key of
UNITNUMBER and this field is related to the UNITNUMBER lookup field in
TBLBOOKINGS. So my query is only returning unit numbers that exist in
the TBLBOOKINGS table. However I do not know how to solve this
problem.

Is there a way to get round this (what I really mean is how do I
design this properly!)?

[Salad]

keri wrote:

Hi, posting again with a more specific question.

I am trying to create a query that checks the availability of a unit
based on TBLUNITS and TBLBOOKINGS. I figured I could run a query to
show available from and to dates based on the TBLBOOKINGS, however if
the unit has no bookings at all it does not show up in my query
results.
I can understand why this is happening, TBLUNITS has a primary key of
UNITNUMBER and this field is related to the UNITNUMBER lookup field in
TBLBOOKINGS. So my query is only returning unit numbers that exist in
the TBLBOOKINGS table. However I do not know how to solve this
problem.

Is there a way to get round this (what I really mean is how do I
design this properly!)?

If you open up the query builder there's probably a link line between
the two tables. Double click on the line. You should get 3 options;
recs from both tables where records match and 2 other options for all
recs from one of the tables and include matching recs from the other.