Dropdown list in one table taken from another table [closed]

asked 2015-01-15 10:55:30 +0100

steven.jandreau.7
1 ●1 ●1 ●1

updated 2020-08-14 22:20:48 +0100

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

20317 ●18 ●59 ●59 http://etmg.altervista...

Libre Office Version: 4.3.5.2

I have have created 3 tables: SOURCE, METHODS OF PAYMENT, PAYMENTS. I want to have the filed payment_methods in PAYMENTS be a dropdown list based on the METHODS OF PAYMENTS field payment_methods. Any help will be appreciated.

Steve J.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-14 22:20:54.823163

add a comment

1

answered 2015-01-16 05:33:03 +0100

frofa

1861 ●6 ●13 ●21

updated 2015-01-16 05:34:49 +0100

Steve:

You may do what you want using either a LIST BOX or a COMBO BOX in your form. Both controls will show a selectable dropdown menu with list of values from the 'foreign' table (i.e. the MethodOfPayment table).

But note the difference: a LIST BOX usually is setup to write the ID number (PK) of the chosen item as a foreign key (FK) in the current row of your Payments table, whereas a COMBO BOX will simply write the value of the choice (i.e. the payment method chosen) into the selected row of the Payments table. See THIS THREAD for more info (especially the post by DACM).