Recent content by sbooth

Okay, I am attaching the altered database. I have created separate tables for category, general location, specific location, and user. This will allow you to create forms to maintain these tables without having to go into the individual forms or queries and changing them. Also, I have changed...

Your problem is probably because you have a database with one table. It is not normalized. You want to break up your data into related tables. When your table structure is correct, your form and queries will be much easier to setup. If you want attach a copy of your db (remove any sensitive...

In your tblProgramme you had 9 fields to enter Providers. There are many providers (more than one). There were many fields in tblProgramme where providers could be entered. This make it a many to many relationship which you want to avoid. Looking at your tables, very rarely are all nine fields...

Okay, I looked at real quick. A couple of things jumped out. One is tblProgramme. It has fields 1 thru 9 to select providers. That is a many to many relationship. What you want is a table that combines these. So you create a table with an autonumber pk and a fk for both the providers table and...

Okay, the form does allow you to add to either categories or skills. Try going to the last line in either subform and either start typing or select an item from the drop down. Then, navigate to another company and come back. It should be there. If you look in the table, it will have added...

The form needs to be prettied up, but is the form in the db that I attached what you are wanting?

zhelyan, I am not totally sure what you are trying to do, but see the attached db and let me know if this is what you are after. I made a few changes to your tables. I added pk's to table_has_skill and table_in_category. Also, you had fields where you were doing your lookup at the table...

Hi Andy. Can you provide either your table structure and/or a copy of your database? If you attach a copy of your database make sure you delete any sensitive data.

Braven944, If you have two combo boxes and you want to be able to be able to select records on either, you will probably need to enter code in the after update Event of both. If you want the selection of one combo box to affect the record source of another combo box than you will need to use...

And the light bulb turns on :). Thank you. I changed the recordsourch and it works!!!

No the record source is tblEntry.

Do you mean the filter by form tool? If this is the case, my problem is that ShowStatusNum_fk is not actually on the form. Maybe I am not understanding what you meant. Also, ShowStatusNum_fk is a number.

I have a form that has a combo box ShowNum_fk the row source is: SELECT [tblShow].[ShowNum_pk], [tblShow].[ShowName], [tblShow].[ShowStatusNum_fk] FROM tblShow ORDER BY [tblShow].[ShowName]; The control source is ShowNum_fk What I want to do is filter the form to show only records whose...

Thank RuralGuy. It worked great.

I have tblShow that has ShowStatusNum_fk. Possible values for this are 1, 2, or 3. What I would like to do is on loading the database... If ShowStatusNum_fk=1 leave it as 1 If ShowStatusNum_fk=2 change it to 3 If ShowStatusNum_fk=3 leave it as 3 Does anyone have any ideas?