Joined: 29 Mar 2012
Location: Ontario, Canada
|Posted: Thu Mar 29, 2012 6:51 am Post subject: Help with Multi table form
|Could anyone please help me with a multi table form with several list boxes? I can not get the tab stops to work. They go from the main form down to two sub forms but will not go past to the next 3 sub forms. Also, I can not seem to delete a record and I am having trouble with one field on the form not populating the table.
This database is a transaction database that records an amount and then distributes it between several account numbers. This is my first attempt at a database and I'm lost after spending an enormous amount of time searching for answers.
ID (primary key) (Integer)
AccountNumber (primary key) (Text(var))
Transaction Type (primary key) (Text (var))
TransactionID (text(fix char))
Transaction Type (Text (var))
VoucherNumber (primary key) (Integer)
MAPAccount (text var))
VoucherDetails (Text var)
Trans Total (decimal)
Table 3 Transaction type (1) to Table 4 Transaction Type (n)
Table 4 Voucher Number (1) to Table 1 Voucher Number (n)
Table 2 AccountNumber (1) to Table 1 Accountnumber (n)
I'm very very new to this (my first database) I'm not sure what information you need to help?