how to add a form with a unique id on jquery?

Type Mismatch error in microsoft Access Form?

• When i create a form using my back end 3 tables which has a relationship, the form opens using form design which is good. Then, i add an existing field, for an example, members id, flowers id, and sale id. They were my 3 tables, and them id's are linked in 1 table. When i add existing fields, i add them using my form and they work perfectly. However, when i add any additional data from different tables with them id in, it says type mismatch error. When i use all the additional data by itself without the id, it works. So basically, i cant add members, flowers and sale id together with any other data within the same tables. It says 'type mismatch error'. Could someone please tell me how to fix this? xD Thanks a lot

• Answer:

  In one of the table the data type is NOT correct; i.e. in one table the members or flower id is numeric BUT in other table the same id got different lets say character or vice versa. Change and make the IDS of exactly same type and try again. Have a nice day. RK