Problem with append query for multiselect Combo Box (has 2 table)

[JHB]

1.plz help JHB...Im begginer in English language and ACCess
you say add field in main db to save the track of list appended table to know from which user???.

In both table "list" and "asli" you need to insert a field, to keep track on from which user the data are coming.
How is the data coming to you from the users and how is it append to the main database. Do you manually run a query, is it automatic or how?
You need to have a unique way to identify the different users, else ...!
So how do you identify from which user the data is coming?
Have you build the 2 databases?

2.in my problem how I can solve my problem by child table?
tanx aloooot JHB...

Under these circumstances you have, I would not suggest this solution, I would stick to solution no. 1.

Did you or your company not consider the possibility to use a WEB database solution?

 

[ahmadrezaahmad]

1-I build one portable.accdb but each user has 1 user name and 1 password.
you guess how I can add field in asli and list table to track the user!
attention:
the query of combo box include:[ID],[staff_name],[staff_family]
and when user select some staff combo box finally show some number(ID of selected staff)

2-can I customize ID in vba that automatically add perfix to ID autonumber,which sync with last user username!!!???