473,323 Members | 1,589 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Combo box linked to foreign key displaying field in primary key table?

Is it possible to build a form with a combo box linked to a foreign key that will display a Description Field from the table containing the primary key?
Sep 14 '16 #1
2 1684
Yes, use combo box wizard
Sep 14 '16 #2
Hi andrualex09

Very easy :

In your combobox property select format tab
  1. In comumn number set up : 2
  2. In column column width : 0cm;2cm --> 0 if you don't want display the PK and cm if your metric setting is in centimeter

Then select data tab
  1. Control source :
  2. Row source type : table/query
  3. Row source: Query name or directly SQL request

You can see this tuto here
Sep 19 '16 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: raj | last post by:
how do i display primary keys, foreign keys that a table has.
2
by: reneeccwest | last post by:
There are two tables, parent and child table. Foreign key field of the child table is not a required field. If the data is submitted w/o a value into the foreign key field, what should I make it...
2
by: suzanne shelton | last post by:
Help! I have two tables that i am wishing to join that involve a multiple field primary key on the primary table. Primary table: ScheduleHistory SID *PK Schedule *PK Secondary...
2
by: 17028 | last post by:
Guys, I'm sure this is pretty easy, I just can't figure out the correct terminology to do a search for it. What I need is basically a text field on one form which is based on table A, and...
7
by: Marco Simone | last post by:
Hi, What is your opinion about using Lookup field in table. I would like to use lookup field in table 1, so that I can choose data in combo box from table 2. Is this good design of database? ...
3
by: Alex Satrapa | last post by:
There's some mention in the (old!) documentation that constraints such as foreign keys won't include data from inheriting tables, eg: CREATE TABLE foo ( id SERIAL PRIMARY KEY ); CREATE TABLE...
4
by: Bonzol | last post by:
..Net 2003, 1.1, Access database. oledb connection Hey there, I had my program updating to the database with a dataset,,, doing things the easy way, binding the dataset to the text box n such,...
1
by: rag1 | last post by:
I have 2 tables and a 3rd table where i have primary keys of other 2 table as foreign keys in 3rd table, now i want to enter values into that foreign key fields how to do this? i am using Access...
5
by: mca47378 | last post by:
Hi, Can we create a foreign key on a table where there is no primary key defined, although the referened table has primary key defined? Thank You, Mithu
2
by: wardwebber | last post by:
I'm building an Access 2007 database by pasting field data from Excel 2007 into corresponding fields/tables in Access. The main Access table, AllDeathRecords, has an autonumbered primary key of...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.