Search results

hi i have tables called staff external and student some of the staff and some of the external people will be supervisors but not all of them the students have 3 supervisors i have now created 2 more tables called external supervisors and staff supervisors and given them an id eg STAFFSUP23...

hi i have a tables called tblstaff, tblexternal, and tblstudent if the external person or staff member is a supervisor i need this in anothe table to give them a supervisor id eg EXTER09 for externel supervisor INTER09 for staff Supervisor this then needs to be linked to the students table...

hi i am trying very hard to build this daabase i dont think there will be a problem when it comes to the forms etc but just getting the tables linked right is becoming a big issue here is the relationship diagram if someone could look at it and give me some advice i would appreicaiate it i know...

hi i have created an input mask for customer ID (>"C":00999) instead of the 00and 99 is there anyway to make this an automatic number so the user wouldnt have to try and find the next available customer id number also is there any way of creating a e-mail input mask thanks for your help emmily

hi could anyone help and tell me if the relationship is in 3rd normal form thanks emmily

i have a report called invoice and fields calld quantity and unit price i have then calculated these in the form to give a total for each product in the page footer i am trying to calculate all the numbers in the totals colum and have tried everything i can think of please help at the minute i...

hi i am wondering if anyone can help i am creating a database with delivery address, a check box called "delivery = invoice" and invoice address i want the invoice address field to be madatory only when the check box insnt ticked i would also like the box to be deactivated on a form and...

hi i am wondering if anyone can help i am creating a database with delivery address, a check box called "delivery = invoice" and invoice address i want the invoice address field to be madatory only when the check box insnt ticked i would also like the box to be deactivated on a form and...

hi i am wondering if anyone can help i am creating a database with delivery address, a check box called "delivery = invoice" and invoice address i want the invoice address field to be madatory only when the check box insnt ticked i would also like the box to be deactivated on a form and...