Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

MS Access 2003 - HELP PLEASE

Jan 10, 2010 5:16AM PST

I am searching for the "Expand Indicator" so i can insert a 'Foreign Key' on my database. I don't know where it is?

Discussion is locked

- Collapse -
Foreign keys
Jan 10, 2010 9:06PM PST

are created in the secondary tables, usually with the same name and data type as the Primary key in the main table. Can you give a clearer example of what is not happening. The expression Expand Indicator doesn't do it for me.

- Collapse -
Expand Indicator in a query
Jan 10, 2010 9:11PM PST

is that checkbox below each column. A foreign key is chosen from the table fields in the query. If checked, this box displays that field but it can be unchecked, if being used say for criteria or sorting.

- Collapse -
Re: foreign key.
Jan 11, 2010 1:44AM PST