Good Morning,
I am using Libre Office 6.3, specifically Libre Office base on Win 10.
I am trying to create a list box in a form that pulls data from several fields in one table to make data entry to another table easier and more consistent.
The table that I am pulling data from is called: Property_tbl and has the following fields:
Property_UID (Primary key)
House_name
House_number
Street
Town
County
Postcode
The table I’m trying to add data to via a form is called Booking_info_tbl and has the following fields:
Booking_info_UID (Primary key)
Property (Foreign key - to Property_tbl primary key)
I have managed to generate a list using:
SELECT “House_Name” || ', ’ || “House_number” || ', ’ || “Street_1” || ', ’ || “Town” AS “Address”, FROM “Property_tbl”
However, not every property has a name so some of the House_name fields in the Property_tbl are blank.
This causes the whole those entries in the list generated on the form to be blank.
How do I overcome this?
Also, is it possible to have 2 columns in the drop down list.
All help greatly appreciated.
Thanks and regards
Chem