I work in a garment production company and I need some help on what I am trying to create:

I have 4 files with the same product ID#.

File 1:

-product id #

-fabric code

...

File 2:

-product id#

-picture

etc...

File 3:

-product id#

-contractor

etc...

File 4:

-product id#

-raw goods id

-raw goods cost

etc...

All 4 files databases are input by different employees. And I am trying to put a check box for completed work by each of the employees, but all I could do is have defined value box where it says yes/no or radio buttons.

isn't there a way of me doing a table that looks like this?

Product ---file #1---file #2---file #3---file #4--

1234--------- {c.b.}---{c.b.}----{c.b.}----{c.b.}---

{c.m.}=check box

p.s.: Thank's for all the help.... Hopefully, this is understandable...

So you want the items in the check box to be the employees' names?

-------------

| O Adam |

| O Brian |

| O Charlie |

-------------

I'm also not sure exactly what your setup is, but my hunch would be: you have a MAIN products file and then these four related data entry files that -- for any given product -- may or may not have related records in them yet, as the employees are completing their separate input process on each product ID?

It seems to me that if you have four (or five) files all on the same product records (different aspects), you may eventually want to combine these aspects into one shared file. But at any rate, it should be easy to automate the record-keeping of what's going on with the various files' records on the same product, once you have the right relationships set up.

One trick is, after setting up a productID match relation between your own file and file #1 (for example), just to put any numeric field from file#1 (a Constant field, or one that you are sure will have a non-zero value if the other file has a corresponding record at all), and have this file show that related field: if you show it as a Boolean result, you can have it display any non-zero value with whatever text (or dingbat, like a checkbox) you like, up to seven characters, like "[x]Pic" or "[x]Fabr" and display zero as "[

No,

is when the product input was finished by the employes

exmple:

Product ---file #1---file #2---file #3---file #4--

___________________________________________________

1234-------- {c.b.}---{c.b.}----{c.b.}----{c.b.}---

___________________________________________________

2345-------- {c.b.}---{c.b.}----{c.b.}----{c.b.}---

___________________________________________________

so forth...

{c.b}=check box where is marked when the employees finished inputing information the specific Product #

"1234" & "2345" examples of product #.

Hope this help a bit

Ronnie:

Each check box would be a field. Define it as a checkbox, and use a value list which has only one item: "Yes" (or whatever). Then, shrink down the field so that "Yes" isn't displayed, just the checkbox. Now, when you click it, it will toggle between checked & unchecked (the data switches between "Yes" and nothing).

-Stanley

Oh....Thanks guys....

It works again, I don't know what to say...

I did not want any words next to it. Thank you so much!!