Hi
I have a DB that i use to record Purchase Orders each PO can have many Bookings and each booking can have many Invoices logged against it, this has been working as I wanted it to until I started to build reports from the info entered. The main thing the reports do is show the liability against each booking however if no data has been entered against the Invoices subform then the report cannot calculate the liability as it cannot subtract a blank field from the PO value. To try and get round this I added a tick box to table Invoices, made the join type the second one and added this tick box to bookings so that when a booking was entered it could be ticked and this would create a record in invoices and a value of zero in invoice value as this field is set to default to zero. This works fine for bookings that have already been created but if I try to create a new booking and tick the box it tells me 'join key of tble invoices not in recordset'
I have looked through the forums but cant find (or understand what I'm looking for...) I'm sure there is a far better way to do what I m am trying to do but my Access skills are fairly limited......if anyone could give me any help on this it would be greatly appreciated
thanks in advance..... Fi
I have a DB that i use to record Purchase Orders each PO can have many Bookings and each booking can have many Invoices logged against it, this has been working as I wanted it to until I started to build reports from the info entered. The main thing the reports do is show the liability against each booking however if no data has been entered against the Invoices subform then the report cannot calculate the liability as it cannot subtract a blank field from the PO value. To try and get round this I added a tick box to table Invoices, made the join type the second one and added this tick box to bookings so that when a booking was entered it could be ticked and this would create a record in invoices and a value of zero in invoice value as this field is set to default to zero. This works fine for bookings that have already been created but if I try to create a new booking and tick the box it tells me 'join key of tble invoices not in recordset'
I have looked through the forums but cant find (or understand what I'm looking for...) I'm sure there is a far better way to do what I m am trying to do but my Access skills are fairly limited......if anyone could give me any help on this it would be greatly appreciated
thanks in advance..... Fi