Add Second Sub Form (1 Viewer)

[access2010]

We would like to have on our Main Form 2 sub forms.

Could I please receive assistance in placing a second sub form form onto our main form
Main Form = Investments_Purchases_SalesF = which already has a sub form
Current Sub Form = Investments_Purchases_SalesF_SubForm

The second sub form I would like to add below the current sub form on the main form is
= Investments_Purchases_SalesF_SubTrading

Should we leave the calculations on the sub form
= Investments_Purchases_SalesF_SubForm
or should the calculations be placed after the = PageBreak107 on the main form
= Investments_Purchases_SalesF

Thank you for your assistance.
Crystal

 

[June7]

Consider placing subforms on a Tab control.

 

[access2010]

Consider placing subforms on a Tab control.

Thank you June7, but I have not been able to find the Add Tab in MsAccess 2003 that we use.

Could you please tell me where to find this control?
Thank you
Nicole

 

[mike60smart]

We would like to have on our Main Form 2 sub forms.

Could I please receive assistance in placing a second sub form form onto our main form
Main Form = Investments_Purchases_SalesF = which already has a sub form
Current Sub Form = Investments_Purchases_SalesF_SubForm

The second sub form I would like to add below the current sub form on the main form is
= Investments_Purchases_SalesF_SubTrading

Should we leave the calculations on the sub form
= Investments_Purchases_SalesF_SubForm
or should the calculations be placed after the = PageBreak107 on the main form
= Investments_Purchases_SalesF

Thank you for your assistance.
Crystal

Hi Crystal
Your 3 tables do not have any referential Integrity set ?

How are these tables supposed to be related?

You have the same Primark Key "Investment_ID" in all 3 tables?

 

[Minty]

Thank you June7, but I have not been able to find the Add Tab in MsAccess 2003 that we use.
View attachment 87573
Could you please tell me where to find this control?
Thank you
Nicole

It's there!

 

[access2010]

Hi Crystal
Your 3 tables do not have any referential Integrity set ?

How are these tables supposed to be related?

You have the same Primark Key "Investment_ID" in all 3 tables?

Hi Crystal
Your 3 tables do not have any referential Integrity set ?

How are these tables supposed to be related?

You have the same Primark Key "Investment_ID" in all 3 tables?

Hello Mike60Smart
How would you suggest to link the tables as the Symbol_Stock and the Stock_Name are / can be used many times for each separate transaction?
Thank you
Crystal

​

 

[access2010]

View attachment 87577

It's there!

View attachment 87577

It's there!

Thank you, Minty.​

I looked for this control MANY times but could not find it until to-day.​

Nicole

 

[mike60smart]

Thank you, Minty.​

I looked for this control MANY times but could not find it until to-day.​

Nicole

Hi Nicole

Each table should have it's own Primary Key ie Investments Table is InvestmentID
You then have 2 related tables and each of these will have their own PrimaryKey ie
Sales Table is InvestmentSalesID
Trading Table is InvestmentTradingID

Now if you look at the Relationship Diagram you will see that InvestmentID Primary Key is linked to both of the other tables on InvestmentID Foreign Key

Hope this helps?

 

[access2010]

Consider placing subforms on a Tab control.

G.R.E.A.T. idea and thank you.
Nicole

 

[access2010]

Hi Nicole

Each table should have it's own Primary Key ie Investments Table is InvestmentID
You then have 2 related tables and each of these will have their own PrimaryKey ie
Sales Table is InvestmentSalesID
Trading Table is InvestmentTradingID

Now if you look at the Relationship Diagram you will see that InvestmentID Primary Key is linked to both of the other tables on InvestmentID Foreign Key

Hope this helps?

G.R.E.A.T. idea and thank you, I do not know why this was not done years ago..
Nicole

 

[mike60smart]

G.R.E.A.T. idea and thank you, I do not know why this was not done years ago..
Nicole

Glad to help