silentwolf
Well-known Member
- Joined
- May 14, 2008
- Messages
- 1,216
- Office Version
- 2016
Hi guys,
I made a misstake and have created a table with ID , Date, Amount, SupplierIDRef (FK), KennIDRef(FK)
However now I like to change this into two tables for example like this
tblSupplierBills and tblSupBillDetails...
in other words I like to split the Bill of the supllier into two tables.. how can I achive this by a query withouth entering again all Bills again?
Hope this is understandable and someone can give me a bit of help with this..
Many thanks
SW
I made a misstake and have created a table with ID , Date, Amount, SupplierIDRef (FK), KennIDRef(FK)
However now I like to change this into two tables for example like this
tblSupplierBills and tblSupBillDetails...
in other words I like to split the Bill of the supllier into two tables.. how can I achive this by a query withouth entering again all Bills again?
Hope this is understandable and someone can give me a bit of help with this..
Many thanks
SW