Search results

Hi Holger Thanks for posting, but i figured out a pretty crude way of doing it using just formulas

Hi all, I hope someone can help with this.... I have a column of numbers, 1's and 0's... I would like to search through the column until i come to the first 0 in the sequence. I would then like to check if the next number is a 0. If the next number is NOT a 0, then I would like to move on to...

Hi Rabbie Yeah, I hadn't added anything into that joint table, because i dont fully understand it in all honesty.... Ok, i'll hopefully speak to you soon. WR

Hi Rabbie... I have attached the jpg to show the inclusion of the juntion table... I have also attached a zipped copy of the Db - please excuse the long path; because ive moved it back and forth between home and work a few times... will sort it when im finished.

Hi Rabbie Not sure the best way to do this... I've attached a screen dump of the relationships... I have exported all the tables designs to a word document, which im happy to email you if it helps?

Hi there I have made the changes suggested: When I create a new record, I must now select a headset ID from the combo box, as it's now set to required. But when I enter a date, I'm still getting the duplication error "The changes you requested to the table were not sucessful because they...

So you've actually given me more than I was after, haha, brilliant!! Ok, I'll give this a blast later, and get back to you. Thanks again for your replies chaps WR

Hi there Thanks for your response. The reason I have set the headset ID to not required is that if it is required, this means that an agent can only exist in the agents table, if they have a headset assigned to them. I suppose this is really the crux of the database, in that an agent SHOULD...

Hi Thanks for replying The fields for the 2 related tables are as follows: Agents table - Agent Novell ID; Primary key, required, indexed (no duplicates) Agent First Name; Required, no indexed Agent Surname; Required, not indexed Dept ID; Required, indexed (duplicates ok) Manager ID...

Hi there, I'm working on a database just now which will store user information, and headset details - for a call centre. Currently everything is working fine, except one thing which is driving me mad: - I have a form to add new records, containing the following fields: Agent Novell ID -...