Search results

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!"

I don't think you have set up your table relationships correctly. I have modified them to what I think is correct

This seems to work using different products and measurements

Can you give an example of some of the other products?

I might have cracked it a (Right[Description],12) seems to give the result your after

I just edited my last post with an attachment

Possibly split the field in 2 and Description and Dimensions and sort by Dimensions or better still instead of a leading 0, add a space, it will sort and look correctly

Solid American White Oak Flooring - Nature Grade - 75mm x 19mm Is this all one field?