Search results

A little clarification I would like to re-state the fact that a "staff member" and "assistant" are the same thing in my staff table. In my tables i was going to use the internal phone extentions as the primary key in the staff table. In my assistants table i was going to base the PK on both the...

I am trying to make a contacts telephone database. Staff(TelephoneNumber, Name, Team) Assistant(TelephoneNumber, AssistantNumber) A staff member my have several assistants or people who work closely with then in the same team. So if the person I was trying to call is not available i can try an...

I have a sub-form on one form which I want to copy data from onto another sub-form on another form. I have a button on the form which loads the second form and creates a new record at which point I want to copy the relevant data from the first sub-form to the second one. How is this possible...

When a client order is placed it removes the stock from the product file. When a product falls below a curtain amount it is placed on order in the purchase order table. The purchase order is then sent to the relevant supplier. Could you please tell me how you think that i should link the...

Just relevant data it is not a foreign key!

Accident It was just a mistake. Sorry, I should have mentioned that.

Can some genius please tell me if my database is in 3rd normal form? Relationship diagram Thanks for the help Martin.

Thanks Thats given me a lot to get on with. Thanks Martin

Relationships and tables! Take a look at my new relationship diagram please. I am trying to make a stock control system for a small shop that takes order as well as "normal" transactions. Have i made the correct relationships between them? I have several tables all connecting to the same field...

For a report i have two fields. If these two fields are equal then i want them omitted and another one in there place. How would i go about doing this? Thanks for the help Martin.

It only ever changes the grade from the first subject reference(01325), it does not pick out the right subject! There are several subjects with different grade boundaries. I hope that you can understand my ramblings. Thanks Martin

More details Subject reference is a text. The sql is on the on update event of the drop down box Subject_Reference. tblScript(CandidateID, SubjectReference, OriginalMark, OriginalGrade) This table contains more stuff but is of not consequence. tblGradeBoundaries(SubjectReference, a, b, c, d...

Select * from tblGradeBoundaries Where SubjectReference = " & Me.Subject_Reference & "; This is the code that is attached to the on update event. I am trying to select a record from a given value from a drop down box. I just can not seem to get it to work. Any ideas would be much appreciated...

What is Me and is the ] ment to be there or should there be anothere one?

All the coding is taking place in access so i have not personally connected to the database. The data is input into the table via a form, then when the recorded is added i want the grade to update itself depending on the subject and the mark. I hope that this helps a little.

Select Case [tblScript].[OriginalMark] Case Is < [tblGradeBoundaries].[E] [OriginalGrade] = "U" Case Is < [tblGradeBoundaries].[D] [OriginalGrade] = "E" Case Is < [tblGradeBoundaries].[C] [Original Grade] = "D" Case Is < [tblGradeBoundaries].[B]...

What would be tghe correct syntax for this? Thanks very much for the help so far, i don't need to list names you know who you are.

Can i search my grade boundaries table for the correct grade? i.e IF mark < value in field Math D then

There are many different subjects with different grade boundaries. How do i account for that?

But how do i do it? Do i need to write a model in VB code or SQL? i just don't get it!