Recycling Field Names

[misschanda via AccessMonster.com]

I am designing a research database for the R/D department. When a product
name is made (Product Name is a Field Name) it goes through success or
failure measures. Only if the product is successful does it retains its
product its name and when it is successful it can no longer be used again. If
the product name is unsuccessful, the name can be recycled and used again for
other future test.
Therefore I would like to make it possible to have the unsuccessful product
names group as in 2222 F1, 2222 F2, 22222F3 and so on, were F1 is the first
failed attempt and F2 is the second failed attempt.

Do you guys have any suggestions.. Thanks
LA.

 

[KARL DEWEY]

DO NOT NAME fields with the product name. Make a record for the product with
it's successes or failure as a date field. Add an archive (Yes/No) field to
retain the historical information.

 

[misschanda via AccessMonster.com]

I am not sure if I am understanding or if I pose the question correctly. The
Product Name is a Field name that hold the numbers for example 2222. Are you
saying do not have a field name [Product Name] and if so, how will I
distinguish the records.

I will try what you have written and let you know the results. Thanks
LA

DO NOT NAME fields with the product name. Make a record for the product with
it's successes or failure as a date field. Add an archive (Yes/No) field to
retain the historical information.

I am designing a research database for the R/D department. When a product
name is made (Product Name is a Field Name) it goes through success or

[quoted text clipped - 8 lines]

Do you guys have any suggestions.. Thanks
LA.

 

[KARL DEWEY]

No, it appeared to me you were using 2222 as a field name.
Have a table just for [Product] with fields like StartDate, EndDate, and
Archive. If the product is archived it can be use again.

For product testing use fields like this --
[Product Name] - 2222
[Test] - 1
[TestDate] - 8/22/07
[Fail] - Yes


--
KARL DEWEY
Build a little - Test a little

I am not sure if I am understanding or if I pose the question correctly. The
Product Name is a Field name that hold the numbers for example 2222. Are you
saying do not have a field name [Product Name] and if so, how will I
distinguish the records.

I will try what you have written and let you know the results. Thanks
LA

DO NOT NAME fields with the product name. Make a record for the product with
it's successes or failure as a date field. Add an archive (Yes/No) field to
retain the historical information.

I am designing a research database for the R/D department. When a product
name is made (Product Name is a Field Name) it goes through success or

[quoted text clipped - 8 lines]

Do you guys have any suggestions.. Thanks
LA.