Jump to content
Sign in to follow this  

Related files and dropdowns

Recommended Posts

Dropdown menu that I want to show records from a related table does not react to focus or click. Created two tables, Name and Department. Here's description from Define Database window:

Table: Name

Field Name| Type | Options

name_ID | Number | Auto-enter Serial

first | Text

last | Text

dept_ID| Number | Indexed

Table: Department

Field Name Type Options

dept_ID Number | Indexed |Auto-enter Serial

deptname | Text|Indexed, By Value List, Existing, Allow Override

description |Text

In the Relationships window I dragged a line from department.dept_ID field to name.dept_ID.

I checked the "Allow creation of records in this table via this relationship" and "Delete related record in this table when a record is deleted in the other table" under the "name" table but did NOT check these same boxes under the "department" table. Populated this table with three records:

Dept 1

Dept 2

Dept 3

Created a layout with First and Last from Name table and department.name from department table. Double clicked this field to display "Field / Control Setup" window and chose these options:

Control Style > Display as: Drop-down List

Display values from: Departmentname

Include arrow to show and hide list

Display data from: department

Can't select (focus on) dropdown menu.


Thanks in advance. As you can tell, I'm very new at this...

Share this post

Link to post
Share on other sites

Welcome aboard. Your control on the name layout should use the name.dept_id field. Then, you need a value list in the dept table that includes dept_id and dept_name. Use that value list in the definition of the name.dept_id control on the name layout.

As an aside, is it your intention to delete any (and all) names from the name table if you delete their department? That's what the delete related toggle will do. What I mean is this: if you have Bob, Jim and Jane assigned to Dept 2, and then you delete Dept 2, Bob, Jim and Jane will all get deleted at the same time. This may be what you want, but I thought I'd check...



Share this post

Link to post
Share on other sites

Thanks, problem solved. Thanks also for reminder to (re)consider delete implications. Not sure anything I'm doing at this point is actually "intentional." :B

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.