Drop Down data not filling in table
Drop Down data not filling in table
I have created a form with 2 drop downs and have the correct info linked. When I test the form and select the items to be recorded in the table, it only records zeros... what's the deal?
OpenOffice 4.1.2 on Windows 7
Re: Drop Down data not filling in table
We can not know because we do not see your document. [Forum] How to attach a document here
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Drop Down data not filling in table
Here's the database...
- Attachments
-
- Warranty Tracker.odb
- (15.52 KiB) Downloaded 195 times
OpenOffice 4.1.2 on Windows 7
Re: Drop Down data not filling in table
List content: SELECT "Status", "Status ID" FROM "War_tbl_3"
because you want to write the integer ID of the chosen status string into the integer "Status" field.
because you want to write the integer ID of the chosen status string into the integer "Status" field.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Drop Down data not filling in table
In the table it's recording the number, not the actual type or status.
OpenOffice 4.1.2 on Windows 7
Re: Drop Down data not filling in table
and therefore you listbox has to write the "Status ID" number and not the "Status" string.Aggieland wrote:In the table it's recording the number, not the actual type or status.
First column is visible (typically some string), second column ist the actual field value (typically another table's ID number).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice