Though this Database in Access 2007 is strieght forward. But after creating
all table and relationship I am little confused. Need some direction please.
This database is for my Items collection, which I want to put data in and then track the items and make reports. Please bear with me I will attach DB.
There are four Data tables...
1. tblCountryTypes ( CountryTypeID pk auto, CountryID num fk, UsageTypeID num fk ) in this table I have created CTypeIndx Unique
with CoutryID + UsafeTypeID reason being I just wanted to add only
one record of CountryID+UsageID so ther are no duplications.
2. tblPostalIssues (PostalIsuID pk auto,CountryTypeID num fk, and other fields.)
3. tblPostalIsuDtls (PostalIsuDtlId pk auto, PostalIsuID num fk, other fields)
4. tblItems (ItemID pk auto, PostalIsudtlId num fk, other fields.
rest of other tables are lookup table for relative data fetching.
For Input form I thought of two approach.. 1. to make use of Tab control
and link master and child field OR 2. Make single form for Data entry
and synchronized other tables.. What would be suggestion please.
For Tabl control I had made it but i this new copy I can not link Master
and Child Field respectively. Also one more question Should I base my
Entry form on query or Table namely tblCountryType ?
Any help will be highly appreciated PLEASE.
Thanks in Advance...
arif Khalak
all table and relationship I am little confused. Need some direction please.
This database is for my Items collection, which I want to put data in and then track the items and make reports. Please bear with me I will attach DB.
There are four Data tables...
1. tblCountryTypes ( CountryTypeID pk auto, CountryID num fk, UsageTypeID num fk ) in this table I have created CTypeIndx Unique
with CoutryID + UsafeTypeID reason being I just wanted to add only
one record of CountryID+UsageID so ther are no duplications.
2. tblPostalIssues (PostalIsuID pk auto,CountryTypeID num fk, and other fields.)
3. tblPostalIsuDtls (PostalIsuDtlId pk auto, PostalIsuID num fk, other fields)
4. tblItems (ItemID pk auto, PostalIsudtlId num fk, other fields.
rest of other tables are lookup table for relative data fetching.
For Input form I thought of two approach.. 1. to make use of Tab control
and link master and child field OR 2. Make single form for Data entry
and synchronized other tables.. What would be suggestion please.
For Tabl control I had made it but i this new copy I can not link Master
and Child Field respectively. Also one more question Should I base my
Entry form on query or Table namely tblCountryType ?
Any help will be highly appreciated PLEASE.
Thanks in Advance...
arif Khalak
