Populating z_Company_ID in the Contact table.

Classic Servoy
1

Tables: Company and Contacts.

Form: Contacts Entry Form

Goal: Populate the z_Company_ID (Foreign Key) with values from the Company table.

I have four fields on the form, Last_Name, First_Name, z_Company_ID and Company Name. I am attempting to enter in the name information and then associate the record with a Company record using a ‘Value List’.

Unfortunately, everything I tab into the z_Company_ID field with it’s ‘Value List’, a value list does not show up.

Most likely I am missing something simple on this. Any assistance would be greatly appreciated.

Cheers,
Dino

2

Hey Dean,

Make sure when you’re in designer mode, that you have the field’s display type set to Combo Box and not Text Field. This should do the trick.

Adam

PS - Nice to meet you yesterday