help with design of form

[mrbboy]

I am trying to develop a form for the calibration of balances. Each balance can be calibrated using one or more weights. The table is:

tbl_Calib
CalibID (Autonumber)
CalibDate (date)
AnalystID (number)
BalanceID (number)
MassID (number)
MeasuredMass (number)

I have a form that has the following controls (The ID field is not visible):

txt_CalibDate - entering the date
cbo_Analyst - Name of analyst performing the measurments
cbo_Balance - Which balance is being calibrated
cbo_Mass - What mass to use for calibration. You can use one or more masses depending on the balance.
txt_MeasuredMass - ACtual measurement

If I enter the calibration amounts one by one, this works great. However, since the values in txt_CalibDate, cbo_Analyst and cbo_Balance do not change, is there a way to save these values in the table but have different values for the MassID and MeasuredMass? For example, curently if Balance1 needs to be calibrated for 1, 2 and 5 grams, the analyst will have to select enter the date, select his name, balance ID three times, with each incidence having a different MassiD and MeasuredMass. I just want to save the analyst some time by only entering values in txt_CalibDate, cbo_Analyst and cbo_Balance once, instead of doing however many times that the balance needs to be calibrated.

 

[mrf1xa]

Strictly speaking your table structure does not facilitate what you want. If there is a one to many relationship between the balance ID and the tests carried out on that balance, they should ideally be in table to represent that. Probably best achieved by having a separate table for the balance measurements, with balance ID as a foriegn key from your existing table and then fields for mass and measurement. May be wise to include date as well. Then you can have a subform based on the new table, and the data on the mainform can remain static while you add ,multiple mass and result entries.

Hope this helps

Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

 

[GingerR]

I agree with Nigel. The existance of your question alone indicates that you need a second table, and you've explained yourself how that needs to be done.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html