G
Guest
Hi, I need to join two fields in the same table into a third field in the
same table.
field 1= group_id (can be 1 or 2)
field 2 = person_id (starting at 001 and continuining)
new field: subject_id (combination of group_id and person_id)
I would like this to be automatic when I type in the first two fields, but I
not sure if that can be done.
Do I need a query, or can I write some code somewhere?
I'm confused whether a query is needed, but I did make one, but it seems to
work ok in the query, not when I use it in the table. Maybe I'm using it
incorrectly.
Any help would be appreciated.
same table.
field 1= group_id (can be 1 or 2)
field 2 = person_id (starting at 001 and continuining)
new field: subject_id (combination of group_id and person_id)
I would like this to be automatic when I type in the first two fields, but I
not sure if that can be done.
Do I need a query, or can I write some code somewhere?
I'm confused whether a query is needed, but I did make one, but it seems to
work ok in the query, not when I use it in the table. Maybe I'm using it
incorrectly.
Any help would be appreciated.