I've created a little join table.. which tracks Committee Enrollments

I have two other tables People and Committees

Can an FP7 value list be called from the join table, but be auto-generated from the serial # fields from the tables I am joining.

I thought this shoudln't be a problem.. but I tried it, and when I create a new record on the join table, the field which should show me the value list being generated from the other table generates no values.

Any ideas what my problem could be ??

I could send you my .fp7 file if that helps.

I'm using a text format for the automatically generated serial field... PE1, PE2, PE3 for person_IDs if that matters.

Thanks

Steven

--

You should probably make your file an attachment on this site - its not entirely clear what you mean, so seeing the file with a description of what list you want to see would help.