i have an mdb with lot of tables in it. But now since the old mdb is not so flexible the way user wanted, the requirement is creating a new mdb with different tables some of them matches the way the old table but some it is combination of fields from more than table in old mdb.
For example old.mdb table name: associate Fields : first name, last name. personid
table name: Network Fields : network id, person id
New mdb
table name associate: firstname, lastname, personid, networkid
How do i do it?
For example old.mdb table name: associate Fields : first name, last name. personid
table name: Network Fields : network id, person id
New mdb
table name associate: firstname, lastname, personid, networkid
How do i do it?