Search results

If you look in the sample templates at issue web database, that is very similar to what I am trying to do. I have followed the instructions to convert it over to client so I can see the design view. I can't load it in here, it's too big.

I need to take a class or 10. Now I'm lost. What I am trying to do may not even be the right program. I have one audit. Each audit has 12 topics. Each topic has 5-6 fields. Each field has 4 possible results. The possible results are the same for all fields. I have tried making each topic a...

Never mind, it was a "allow multiple values setting"

I now have all the tbales linked with a key and foreign keys and it's doing pretty much what I want it too. I wrote the values in each table seperately with the look up wizard and it looks right, but one of the tables isn't giving me the little check blocks to select the results. All the...

Pat, Did I do what you wanted?

Relationship Removed. This is all but two tables. I really appreciate the help.

Right, I didn't think about that. Safe At Risk At Risk+Mitigated Not Applicable That should work.

Pat, I will need to select more than one value in some cases. For example At Risk + Mitigated. In fact that may be the only case. I will make a copy and remove the relationships.

Here is a bigger piece. The difference between this one and the actual one is I have 3 more tables like the housekeeping table here. What I would like to do is link the tables together so it makes like one big table. And build forms, queries and reports so my guys can put the information in...

Here is a piece

I should add I don't know the first thing about VBA.

I don't know what that is, I'm off to do research. The data is basically the same layout, with different field titles. If I build the 9 tables, am I right in thinking that using the ID autonumber from table one as a foreign key in the rest of them will link them together?

Thank you Pat. I have nine groups with roughly 4-5 items in each group. Each item has a result out of a possible 4. I put the results in a table and was using a look up for each of the group, as you said like a spread sheet. I am in the process of separating the 4 groups into seperate tables.

The problem was I had too many fields in my table. I split it into three parts and it worked fine. Now I have to figure out how to link the 3 parts so they stay together.

Yes Sir, But it isn't giving me a "copy" option. IO was hoping there was a way to combine and merge them. It's ok, I'll just start over. Good practice. THanks for replying.

I have 10 tables. None of them have any entries in them. Just field names. Is there a way to combine them all into one table.

Now that I'm doing ok with this and have learned something, I would like to do something a bit different. I have fields that were set as short dates that I had to change to text so I could add the word "Exempt" to certain entries. So now I am adding dates and "Exempt" in the same field. I...

Right, I'm with you. What I was actually hoping to do is make the field name a hyperlink so I wouldn't have to have a whole other field.

Is there a way to insert a hyperlink in a field title on a table? For example, I have a field that is a check box for whether the person has taken a class. What I would like to do is insert a link in the field title for that class so I can click on it and bring up the supporting documentation...

Thank you. Much appreciated.