I'm at my wits's end with this but I bet the answer is simple! Hopefully one of you clever lot can help me...
Here is my script:
(ooxml, embedded labels, table is Users);
(ooxml, embedded labels, table is Films);
There are 5 records in the User table, and 8 in Films. User #5 doesn't have any records in Films. Therefore, I want an entry in a Films listbox with <None> that is selectable. I have tried using IsNull and LEN in the script to no avail. Help!
Typically though, after spending DAYS on this I found another solution just after posting my question! As I have many more tables to join, all of which might have missing values related to the mater User table I think this second way will be a bit tidier. See attached example.