Dreamweaver
Well-known member
- Local time
- Today, 12:58
- Joined
- Nov 28, 2005
- Messages
- 2,466
I'm Just starting work on a section of a project and need a bit of network advice
Local table version
I'm going to build a grid form with a 30 fields and 30 rows (There may be a few more) grid this will be coloured Depending on the object(s)
The Local table will be filled from a data table in BE as below
AreaID PK
CtrID PK
RowID PK
LocationID
ObjectID
MachineID
EmployeeID
The downside to the local table version is Blot and coding will be more complex but not a problem.
If I create a Datafile In BE table It would use 30 rows (Depending on final grid size) and 62 Fields for each areaID
ID PK, Auto
AreaID FK
D1-D30 Would contain an Array of Elements like C123456,L:1,O:0,M:25,E:0 See list above data table
It would be simpler to code but my question is which would be best for a network
Thanks mick
Local table version
I'm going to build a grid form with a 30 fields and 30 rows (There may be a few more) grid this will be coloured Depending on the object(s)
The Local table will be filled from a data table in BE as below
AreaID PK
CtrID PK
RowID PK
LocationID
ObjectID
MachineID
EmployeeID
The downside to the local table version is Blot and coding will be more complex but not a problem.
If I create a Datafile In BE table It would use 30 rows (Depending on final grid size) and 62 Fields for each areaID
ID PK, Auto
AreaID FK
D1-D30 Would contain an Array of Elements like C123456,L:1,O:0,M:25,E:0 See list above data table
It would be simpler to code but my question is which would be best for a network
Thanks mick
Last edited: