I have a problem I have noticed approx 6 times, only solution is to switch off and restart the computor.
I suspect it may be caused by my set design.
I have three tables:- a client name table, and a firm table. They are linked by a linking table which has two fields, a client number and a firm number.
(I think I was told that is good practise.)
I want to select a client with all the firms he may work for, or alternatively select a firm with all the employees.
In one set configuration, client/firm set, the client is the parent, linked by clinumber field to the child linking table one-to-many; the linking table is linked by firmnumber field to the grandchild firm table one-to-one.
In the other set configuration it is the reverse. Firm table as parent linked to linking table on firm number, linking table to client table on client number.
Either one works fine, and normally both work fine, but sometimes it seems like I have lots of Alpha A5's suddenly installed:- across the top of the page where it says "file edit view form records" etc it repeats itself approx 3 lines, and yesterday I got lots of blurred A5 images superimposed one on another at a re-start up.
Frm the kind advice of A5 helpline I have installed the patch from the update board, but the problem has occured after that update and restart.
I am thinking I need to use some kind of conditional linking to avoid the problem of "ring-around". If I cut the set design of one configuration the other works fine. The first was working fine until I made the reverse configuration. But I cannot get it to make a problem consistantly. I don�t want to make conditional anythings which are not required, to avoid complications in future.
We have situations where some clients work for different firms at different times, and some firms have many employees. Thus the linking table may be causing a continuous circle of a client linked thru the linking table to a firm, which is linked back thru the linking table to the same client; or another client who is then linked backed to the same, etc. Could that be the problem? I expect this is a normal problem about which I should know, but I am new to this.
Brian.
I suspect it may be caused by my set design.
I have three tables:- a client name table, and a firm table. They are linked by a linking table which has two fields, a client number and a firm number.
(I think I was told that is good practise.)
I want to select a client with all the firms he may work for, or alternatively select a firm with all the employees.
In one set configuration, client/firm set, the client is the parent, linked by clinumber field to the child linking table one-to-many; the linking table is linked by firmnumber field to the grandchild firm table one-to-one.
In the other set configuration it is the reverse. Firm table as parent linked to linking table on firm number, linking table to client table on client number.
Either one works fine, and normally both work fine, but sometimes it seems like I have lots of Alpha A5's suddenly installed:- across the top of the page where it says "file edit view form records" etc it repeats itself approx 3 lines, and yesterday I got lots of blurred A5 images superimposed one on another at a re-start up.
Frm the kind advice of A5 helpline I have installed the patch from the update board, but the problem has occured after that update and restart.
I am thinking I need to use some kind of conditional linking to avoid the problem of "ring-around". If I cut the set design of one configuration the other works fine. The first was working fine until I made the reverse configuration. But I cannot get it to make a problem consistantly. I don�t want to make conditional anythings which are not required, to avoid complications in future.
We have situations where some clients work for different firms at different times, and some firms have many employees. Thus the linking table may be causing a continuous circle of a client linked thru the linking table to a firm, which is linked back thru the linking table to the same client; or another client who is then linked backed to the same, etc. Could that be the problem? I expect this is a normal problem about which I should know, but I am new to this.
Brian.
Comment