Hi,
After making tables and relationship in Access 2007
Database..I am sort of confused and got stuck.
some help finger pointing to direction probably put
me in right direction.
Purpose of Database is to keep track of Inventory
(collection) and generate different reports. Main I have seven tables other
tables stationary for Look ups.
1. Table tblCountries and UtblTypes are also look up tables.
3. tblcountryNTypes created as Junctional table with fks of CountryID
and stmpusageId to make non duplicate record -- with combinedKey and
Auto number Pk.
Note: I have made at table level look up at present just to see data. this
will be removed later and in the form combo box look up planning
to use.(query)
4. tblcountryNTypes 1:M tblPostalIssues..
5. tblPostalIssues 1:M tblPostalIsuDtls
I created Postal Issue Detail table because Same subject (Theme),
Titte can have different Denom or Place of Issue etc..so instead of
adding duplicate record in tblPostalIssues I created tblPostalIsuDtls.
6. tblPostalIsuDtl 1: M tblStamps
7. tblStamps 1:M tblStampSpecs.
For Data Entry Form based on tblCountryNTypes. I took approach using
Tabs. Problem is that when in form combo box selection if I try
second record of Same country with same Stmpusagetype
Error is thrown (obvious relationship constrains) I can not back down.
Should I use Unbound combo boxes instead Bound Combo Boxes.
or use cascading Combo box ?...
I tried Other approach by making query.. and Created
Form from based on that query. Hurdle came if all fields
not filled.
Specially record field related tblPostalIsuDtls in the query.
I was not able not insert record. I have deleted query
as well as form. any direction to take help be very helpful. Also
very sorry to write all this lengthy narrative.For Tab control problems
Mike Smart helped for which am highly obliged and Appreciate Highly.
attach is Db too.
View attachment KTestDBV019ua.zip
Thanks in advance.
Khalak
After making tables and relationship in Access 2007
Database..I am sort of confused and got stuck.
some help finger pointing to direction probably put
me in right direction.
Purpose of Database is to keep track of Inventory
(collection) and generate different reports. Main I have seven tables other
tables stationary for Look ups.
1. Table tblCountries and UtblTypes are also look up tables.
3. tblcountryNTypes created as Junctional table with fks of CountryID
and stmpusageId to make non duplicate record -- with combinedKey and
Auto number Pk.
Note: I have made at table level look up at present just to see data. this
will be removed later and in the form combo box look up planning
to use.(query)
4. tblcountryNTypes 1:M tblPostalIssues..
5. tblPostalIssues 1:M tblPostalIsuDtls
I created Postal Issue Detail table because Same subject (Theme),
Titte can have different Denom or Place of Issue etc..so instead of
adding duplicate record in tblPostalIssues I created tblPostalIsuDtls.
6. tblPostalIsuDtl 1: M tblStamps
7. tblStamps 1:M tblStampSpecs.
For Data Entry Form based on tblCountryNTypes. I took approach using
Tabs. Problem is that when in form combo box selection if I try
second record of Same country with same Stmpusagetype
Error is thrown (obvious relationship constrains) I can not back down.
Should I use Unbound combo boxes instead Bound Combo Boxes.
or use cascading Combo box ?...
I tried Other approach by making query.. and Created
Form from based on that query. Hurdle came if all fields
not filled.
Specially record field related tblPostalIsuDtls in the query.
I was not able not insert record. I have deleted query
as well as form. any direction to take help be very helpful. Also
very sorry to write all this lengthy narrative.For Tab control problems
Mike Smart helped for which am highly obliged and Appreciate Highly.
attach is Db too.
View attachment KTestDBV019ua.zip
Thanks in advance.
Khalak
