form / table design

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

I have a list of items that could have a value or might not.

The way I would usually do this is each item has a code and each record
consists of a ProjectNo, a code and a value, thus the table only containing
the items that have values in a vertical.
eg Project1 Code1 £1000
Project1 Code3 £50
etc

PROBLEM
The users want to see the complete list when a new record is opened so I
believe that this would mean that each record will look like:

ProjectNo Code1 Code1Value Code2 Code2Value etc

Which seems to complicate things for querying and reporting.

QUESTION:

What would be the best way to present and code this so that the user gets to
see all the items on the form but the table can be in the structure of
ProjectNo Code Value
xxxx xx 1000
xxxx xxx 50

Thanks
 
Hi,

You basically want to use a continuous form. You want to line your controls
up in the detail section of your form vertically so that they are all side by
side by side.....all in one row. You want to size the detail section of the
form just big enough for the controls to fit....no extra room over or under
them in the detail section.

Normally, people cut the label part of a control off and paste it from the
detail section into the head section to use as a column header, but in your
case, you want to keep them together. You can go back and add additional
column headers later if you think you need to. Your detail section of your
form should basically look like this:

|Project# ||Code1Label ||Code1Value ||Code2Label ||Code2Value |

I'm not sure you need a label with the project#, but that's your call.

Again, continuous form, everything lined up in one horizontal line, and NO
SPACES between the line of controls and the top of the detail section OR the
bottom of it (and, no spaces between controls, horizontally, either!).

HTH,
CW
 
that doesn't work coz it is still one record.

I want each of the controls to represent a new record in the table (with a
structure of Project, Code, Value)

Is there a way of AUTOMATICALLY creating the 10 records in the table for the
set codes without any value - a sort of template?

Thanks
 
Back
Top