Kristeen Newbie

Joined: 29 Mar 2012 Posts: 1 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.
Table 1
ID (primary key) (Integer)
VoucherNumber (Integer)
AccountNumber (text(var))
Amount (Number(numeric))
Table 2
ID (Integer)
AccountNumber (primary key) (Text(var))
Description (Text(var))
Table 3
Transaction Type (primary key) (Text (var))
TransactionID (text(fix char))
Table 4
Transaction Type (Text (var))
VoucherNumber (primary key) (Integer)
DocNumber (text(var))
TransDate (date)
FromTo (Text(var))
MAPAccount (text var))
VoucherDetails (Text var)
Trans Total (decimal)
Relationships
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?
<<<<begging here>>>>>> |
|