Dependent IDs

[dpmnyc]

Hello and thank you in advance....

I cant figure this out:

I have one table called "members" some members have dependents (a second table called "dependent").

I would like to make the dependent_id dependent on the member_id. So, if a member has an id (auto-enter, serial) of 0001 then the first dependent would have an id of 000101, the second would be 000102, and the third would be, 000103. I am NOT at all concerned about the format of the dependent_id's format, it could be a,b,c or use a hyphen or whatever. I am concerend that it be automatically generated, and that it be unique for each memeber (so there would NOT be a 000101, 000101.

Any help would be appricated!

Thank you,

dp

[RalphL]

I suggest that you use a simpler approach. Add a field to the dependent table Member_ID (foreign key). Use an auto enter serial number for Dependent_ID (primary key). A portal in member can show the dependents for that member based on the fields Member_ID.