Jump to content

can't enter data or lookup value lists for related fields


agtjazz
 Share

This topic is 5699 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Just when I thought I had a handle on it, I realize I am more confused. I have the following tables:

People

Contracts

Job Info

Employee Type

Employee Subtype

1 person can have many contracts and job information (as contracts or job info change, it will become history).

Relationship is

People.emp_pk to job.emp_fk

Job.jb_pk to EmpType.jb_fk

EmpType.emt_type_pk to EmpSubType.ems_type_fk

I am setting up a layout for data entry that has people info, then job info (ie hire date, position title) Part of the job info is the Employee Type (ie Faculty, Staff or Student). So I have a drop down/value list for that.

The Employee Type filters down even further into Faculty- Tenured track or Faculty- Dept Chair, Staff- temporary, Staff- permanent). When I try to enter in data, it creates new records in the Employee type table, which I don’t want or it won’t only pull up the related subtypes.

Any help will be greatly appreciated- as at this point I am banging my head against the keyboard

:bang:

Edited by Guest
Link to comment
Share on other sites

I guess I am confused about relationships or related tables and lookups. It almost seems redundant that I have build a relationship between two tables and then make a value list so users can pick from drop down menu. Your advice/guidance will really help me get through these rough learning patches. Thanks in advance

Link to comment
Share on other sites

I have posted a zip copy with fake data in there. On the People layout, on the job tab, I have asked questions re: the employee type and subtype. It seems redundant that I have related tables and also need value lists, so maybe I am completely not misinformed about life with Filemaker. I repeat- Any assistance is really really appreciated.

Thanks in advance for your time.

hrtestingtable.zip

Link to comment
Share on other sites

This topic is 5699 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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