The file itself --->Cascading combo boxes

[StacyStacy]

Here's the database itself

 

[StacyStacy]

Relationships

I did not set the relationships to the tables.

here's the updated db with the relationships set. My apologies.

 

[coryt]

I solved one issue, but now you get an error whenever Address 2 is blank. I'm crashing and burning so I will try to help more tomorrow. Enjoy what I finished so far.

 

[StacyStacy]

Thank you. When I choose a provider via the Provider Code, I would like the Provider Name to appear just below the Provider Code. Next, I would then choose the Location Name via the name itself. I would like the Location Code to appear just below the Location Name. Additionally, I would like the fields below the Location Name to populate with the address information.

Another concern I have is that the data will write the information to a table, not just for viewing purposes. Also, I need the next record to be different from the 1st. Shouldn't the fields need to be bound to the table??

Thanks so much for helping me. I really appreciate it.

 

[coryt]

You are correct. They should be bound to a table however, not the same table in which you use for the row source for the combo boxes. You should create a new table in which information can be stored.

Also, I did get everything to fill in like you asked.

 

[bradcccs]

The Null or Zero Length String error is occuring as your table has the Allow Zero Length property set to NO for the offending fields.

Set this property to YES (As you have some data without Address2 etc) and you will not get the error.

 

[coryt]

I looked all over the properties section for that, and couldn't find it. Is there another way toset it. Address 2 is a text box.

 

[StacyStacy]

Thank you. Would you setup the tables and configure the fields to write to the table for me?

Thanks a bunch.

 

[bradcccs]

coryt: The Allow Zero Length property is in the Table properties, not the form.

 

[coryt]

Ah, got it! I checked the "required" property but forgot to check the "Allow zero length". Thanks.

 

[StacyStacy]

You guys are so sweet. Thank you.

 

[coryt]

What exactly are you trying to do with this db. By changing information, what do you mean?

 

[coryt]

By changing information do you mean:

This database is used to lookup information, IE contact name. If that contact name ever changes, you can edit that field and from then on that new contact name will appear when that record is pulled.????

 

[StacyStacy]

Yes correct. I will ultimately need to link the field to another table not referenced in the db provided.

I will need to look up info as well as write to the tables.
-thx

 

[coryt]

Try This

 

[StacyStacy]

Thanks. I have been pulled on another project and had not been able to download it right away. Thanks so much. Please keep an eye out for my response.

 

[StacyStacy]

It works like I want it to but, I have encountered an error that reads: "Cannot perform cascading operation. It would result in a duplicate key in table". Is there a problem on the table level??
Would you check out my relationships? Thanks.

 

[StacyStacy]

Hi. I am now resuming the completion of this project. Would someone help me out with the following error:

Cannot perform cascading operation. It would result in a duplicate key in table".

Is there a problem on the table level?? Would you check out my relationships? Thanks.