I m preparing a database of members of an organization for keeping the travel record only. I have three tables: tblMembersDescr iption, tblTravelDetail s and tblManifesting. Whenever anyone comes for booking I want to first find whether his/her name is listed or not in tblMembersDescr iption, if it is, then it shows in a form that I designed setting record source of a parameter query basing tblMembersDescr iption, Now I want to append that data from this form to the tblManifesting and in the same field as of tblMembersDescr iption.(e.g, [name], [id] and [section]).How can I do that? In case of a member not listed in tblMembersDescr iption, can I directly append the new datas into both the tables(tblMembe rsDescription and tblManifesting) at the same time?
I Require your urgent HELP please!
I Require your urgent HELP please!