I'm still struggling to understand what you are doing.
Your original post indicates that
frm-FOREX-BKTST-04 is working to your satisfaction for
SubForm-PRESIND, SubForm-M&M and SubForm-TNT. Looking at your form it appears you have a 1 to 1 relationship between
tbl-Time Chart and the 3 tables
tbl-Pressure Indicator, tbl-M&M and tbl-TNT.The effect of that would result in a relationship diagram something like.
But looking at your relationships diagram there is a
n to 1 relationship between
tbl-Time Chart and the 3 tables tbl-Pressure Indicator, tbl-M&M and tbl-TNT.
If
frm-FOREX-BKTST-04 is correct and you DO have a 1 to 1 relationship, there is a potential problem with your table design. It presumes that the auto value primary keys in
tbl-Pressure Indicator, tbl-M&M and tbl-TNT will remain synchronized with the value in
TIME-CHRTID in
tbl-Time-Chart which is a risky assumption. Anything that causes them to lose synchronization can result in a mess that can be very difficult to sort out.
For a 1 to 1 relationship, it will save you some serious grief if you move all the fields except the Primary Key fields to
tbl-Time-Chart and eliminate those 3 tables.
Also, looking at your relationship diagram I see a 1 to 1 relationship between
tbl-CUR-PAIR and tbl-Entry and another between
tbl-Entry and tbl-Time-Chart that will have similar problems.
Looking again at
frm-FOREX-BKTST-04 it appears that you have a list box for selecting a value from
1st-Currency-Pair and placing it in
tbl-CUR-PAIR. I don't see the point of
tbl-CUR-PAIR, it would be simpler to add an integer field to
tbl-Entry that would be a foreign key related to CUR-PAIRID in 1st-Currency-Pair. Use that integer field as the
Data field in the list box.
Then change the
List content of the list box control
List Box CUR-PAIR to
- Code: Select all Expand viewCollapse view
SELECT "CUR-PAIR", "CUR-PAIRID" FROM "lst-Currency Pair" ORDER BY "CUR-PAIR" ASC
When you make a selection from the displayed list of
CUR-PAIR options from
1st-Currency-Pair the related
CUR-PAIRID will be saved in the new integer field.
It appears to me that you could use a single table to replace
tbl-Entry, tbl-Time-Chart, tbl-Pressure Indicator, tbl-M&M and tbl-TNT.I am also wondering if
tbl-RUN might be better included in the enlarged table.
I'll reserve discussion of
tbl-Pressure Indicator and tbl-Support-Resistance until the above mentioned issues have been resolved.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.8 & LibreOffice 6.4.7.2 - Windows 10 Professional