Show name on form but esave id in third tabl

[waqas]

dear all



i have two tables one tables filed are gid and gname second pid and pname. on form i want to show in combo boxes values only gname and pname but in third table i want to save only gid and pid.

how can i do any one guide me

i have upload combo box with query "select * from group;"

[goodguy]

1. SELECT * is bad practice, learn to write SELECT with fieldnames.
2. GROUP is a reserved word in Access and SQL, DO NOT use it to name tables or fields.
3. User the LOOKUP WIZARD in design view of TABLE3.GID to bind to TABLE1.GID while displaying TABLE1.GNAME
4. Same for PNAME and PID.