Recent content by David Eagar

Apparently, ask Rupert Murdoch!

Far be it from me to disparrage the skills of this SEALS team, but from what I have seen so far of all of this, to shoot an unarmed man in the head, because an unarmed woman ran at you (which they managed to shoot in the leg), does'nt do much credit to them... Unless the only order was to take...

To try and resurrect this moribund forum: Which guitarist had the biggest affect on you? For me, Jimi Hendrix (like the whole planet) Hey Joe - It was this that made me decide I wanted to do this - Some 40 years later, still not within a bull's roar

I think it is possible, but I've never done one, suggest you do a search of the forum as I have seen this subject come up

Something like this?

Something like this - although I would highly recommend you follow the Doc's perscription, he is clearly aware of the subject matter and he knows a LOT more about Access than I do

What version of Access are you using? I will knock something up

For what it is worth, I always base it on the Alpha query

A simplified answer: It sounds very much like the ERP system I used to work with (we made printing inks) either from raw materials our previously blended products) All products went into an Item table and had various flags set (Purchased/Manufactured etc) For the Manufactured Items, a bill...

First Design the Perfect User !!!!!!

You could try something like this

When you append data into a secondary table, Access will not populate the link field for you, you must add that to your data source

Lets go back to basics - if the link is not being populated, then the form where you are entering data is not set up correctly Try this

If the DVT table is to be your primary table (The ONE), then yes, other tables must be linked to it So for patient 201, the foreign key (link number) will always be 201 in the link field in the other tables

The two autonumbers in each table will never always match, it will increment every time there is an entry in that table. By using a foreign key, the second table will always record the autonumber of the primary table - a 1 to many relationship in the words of James Brown "Where is the one!"