Ask Your Question
0

Dropdown list in one table taken from another table

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

steven.jandreau.7 gravatar image

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 close merge delete

2 Answers

Sort by » oldest newest most voted
1

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

frofa gravatar image

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

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).

edit flag offensive delete link more
0

answered 2015-01-15 12:27:25 +0200

Lupp gravatar image

updated 2015-01-16 13:16:30 +0200

Use the validation tool ( > 'Data' > 'Validity' ) with 'Cell range' ...

Sorry! I seem to tend to interpret any question as one about Calc even if expressly tagged otherwise.

edit flag offensive delete link more

Comments

This does not seem to be relevant to the original question (and it seems to be about Calc and not Base).

frofa gravatar imagefrofa ( 2015-01-16 05:38:57 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2015-01-15 10:55:30 +0200

Seen: 848 times

Last updated: Jan 16 '15