Jump to content
Sign in to follow this  
projectstory

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.

:B

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

HTH,

David

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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