Recent content by peregrin

I'm not able to download files at present. But you must have primary keys in both tables to create referential integrity - that could be the issue. If you want to reply with a description of the fields in your tables I can respond with more direct advice.

One thing to be sure to to is try to get a direct command prompt on your mysql server by itself - just to be sure it's working on its own, and that your username, password is correct, and so on. I'm not an expert (I do have a LAMP server running at home with PHP and mySQL that I've played...

Can you independently connect to the MySQL server to make sure it works on its own? For kicks you might try mysqli functions instead of the older mysql functions - if this is a new project it may be best to start out with mysqli anyway since that will be better in future (with unicode support...

Okay. I'm beginning to understand. Interesting about all of your tests that no matter what you did the cursor was a static cursor and the location was client side. What can you say about this database? Anything unusual about it or the data connections? What kind of changing information do...

It looks like between suppliers and parts you need a linking table (sometimes called join tables, junction tables, or associative tables). This "Suppliers_Parts" table will hold the part number and supplier number as a composite key, and the price of the part from the supplier. It's also a...

Okay, got it. I don't see why you'd need joint in this query (you can query for contracts and clients without worrying about contracts and suppliers).

So, do all the subforms share the same recordset? If the subforms reload with the main form then there must be some dependency here.

^^ sounds right. It must be a text field and you are looking for a greater than criterion. For numbers, 32 is greater than 31, but 9 is not. For text, 32 is greater than 32, and so is 9. Might work to record a macro and see how the macro recorder does it - I don't think you use wildcards in...

Do you want a 3 in table 2's priority_CD, or do you want not 1 or 2?

Looks alright. Except sessions isn't really defined, so jury is out on that. This looks less than ideal in a table: Treatment 1 Treatment 2 Treatment 3 Treatment 4 Though strictly speaking this will limit you to 4 *treatments*. Not 3NF though, I guess, if you get down to the nitty gritty.

What do you mean about all these subforms? What are they? How many?

Hi alex, I'm not sure what a joint is. Can you explain that? Otherwise, at first glance, I don't see why YearID is part of the clients table. Seems like (ordinarily) that's a property of a contract, not a client.

Hi, Maybe it would work to put the notes in an unbound field that gets appended to the notes table after the main fields update -- e.g., in an *AfterUpdate* rather than a *BeforeUpdate*. P.