Form Design Ideas

[Steven19]

Hi all

I'm looking for a way of designing a form that operates in the following way. (simplified example below)

Table_1 Contains the field [Country]
Table_2 Contains the field [WOWGR]

I want to design a form that has the data source Table_2 as I will be updated related fields of this table.

However on the actual form, I want a Label to say if [WOWGR] is valid or not. If Table_1, Country = United Kingdom, Table_2 WOWGR Valid, Table_2 WOWGR Not Valid.

I've never tried to do anything like this before so would appreciate some pointers.

There are relationships between Table 1 and Table 2. Each have a Key and Table 2 is a child to Table 1.

I've not started building this yet, but just looking for ways to make this work.



Regards

[mike60smart]

Hi

The normal structure for these 2 tables would be a Main form based on the Country (Parent Record)
and a Subform based on WOWGR ??

It is always best to name a table with a name that relates to its contents.

table1 would be named tblCountries
table 2 would be named whatever WOWGR represents

[Steven19]

Hi Mike

The naming conventions are pretty okay. I've got that down to an art especially after going through an exercise of normalisation with a previous database.

Thanks for the feedback

[Minty]

I think what Mike is trying to say is real table names might assist us in providing you with a sensible solution, and better understand what the fields mean.

Unless they are tb_MybankAccountNumber and tb_MydateofBirthAndMothersMaidenName

In which case the obfuscation makes more sense.

[Steven19]

Okay
So the database is a Duee Diligence Database - we will use it to verify customer due diligence

So, I've got
Table_1: DueDiligence
Table_2: tblCompanyDDIdentity

The Field Country is a DDL called Country

The user will update the Combo Box in the Table DueDiligence, if they select UK, then I don't really need anything to happen, but if they select any other country other than the UK, I have two options.

1. A text box in tblCompanyDDIdentity called WOWGRUpdated can accept avalue of valid or not valid or
2. A Label on a form, (CDDMenu) not yet created to show a lable that says WOWGR Valid if UK is selected.

I'm also trying to get an idea for , if tblCompanyDDIdentity has no new record yet, one will have to be created,

[mike60smart]

Hi Steven

OK so you can make the Subform NOT Visible initially

Then in the Combobox for selecting Country on the Main Form if the user selects anything other than the UK the Subform becomes Visible