Hi all,
I pretty sure that this is a simple question but it'd the details that I don't know. My db need to create and destroy a table during one of the transactions. I need to create some thing (module, macro etc..) that will create a table automatically. Here are the specifics
tempClientOrderLines (COrder_Num, CLine_Num, Prod_ID, CLine_Units, CLine_Price)
Where:
COrder_Num is number (primary key)
CLine_Num is autonumber (primary key)
Prod_ID is text (foreign key references Products table)
CLine_Units is number
CLine_Price is number
I also need it to create the proper relationships
Can anyone tell me how I might go about this?
I pretty sure that this is a simple question but it'd the details that I don't know. My db need to create and destroy a table during one of the transactions. I need to create some thing (module, macro etc..) that will create a table automatically. Here are the specifics
tempClientOrderLines (COrder_Num, CLine_Num, Prod_ID, CLine_Units, CLine_Price)
Where:
COrder_Num is number (primary key)
CLine_Num is autonumber (primary key)
Prod_ID is text (foreign key references Products table)
CLine_Units is number
CLine_Price is number
I also need it to create the proper relationships
Can anyone tell me how I might go about this?