Search results

i have been given the great task of redesigning an existing database that contains nearly 500 records in several tables. The database is in Access 2000 format. The problem is the designer did not normalise the tables before users began entering data. I need to keep all the information as well...

Possible Table design Hi All I have updated my relationships based on suggestions from the forum. About to implement this design if anyone else has any suggestions please let me know before I implement it. For all those that did help me by answering my various questions, espically Pat THANKS. :D

Thanks nuttychick I think you have simulated my problem. Adding to the form seeems to be the only way around this.

Default Values PT2 Sorry Pat my wording was wrong. The form is based on one query but the query contains two tables. The default value for the second table is not automatically displayed on the form when I create a new record, it is for table one.

Hi All I have built a form based on two queries, the form does not contain a sub form. In table design I have assigned default values for my fields. Now when I create the form using auto form. Table 1 fields default values appear in the text boxes on the form when I begin to create a record...

Thanks Pat.

I am doing a database course and this example came up. Why are one to one tables horrible? One thing i learnt is that you use one to one tables for security or if the information is not required to be completed for each record.

Can technical person answer this question? In a one to one relationship is necessary for both tables to contain values, as the other day I had a strange error in access. Example Table A EmID Name Address 1001 J.Brown 123 Palm RD 1002 A.Kay 44 The Avenue 1003...

there is no state as db is for the UK. I have added the personnel tbl twice as suggested by Pat. If i do not add this table twice could I use a query instead to look up the values of employees only, i.e. the type field = "Employee". If not why is adding the personnel tbl twice stronger than...

thanks to those that helped!. If anyone else has any more suggestions let me know. Thanks:D

work number is the main switch board number and direct line is the direct number to your desk phone. You mentioned that I need another relationship between employeeid and the personnel table to enforce referential integrity. Why?

thanks for that suggestion good idea. Can anyone else see a problem with my design?

I have designed a contact database and would like some feed back before I dive in any further. The Plan: I have two main tables, Personnel and Contacts which is a subset of the the Personnel table. The personnel table contains the fields common to both Employees and their contacts. I have...

db Found out what I was doing wrong on the relationship screen do not worry. Thanks for your help

Contacts DB Thanks for your help I have attached a screen shot of my relationships. Why u my ask? Because the relationship window shows that if I implement your suggestion then I have a one to one relationship and have no way of having an employee link to many contacts, or am i reading this...

I have created a contacts database. Table Employees contains records about contacts and employees they are distinguish by a field called type which contains the choice Employee Or Contact. I have a one to one relation which is a subset table called Contact which contains information only common...

Could some one please help. I would like to change the record source of an unbound list box using code. Based on the radio button selected I would like the values in the list box to change. I have been struggling for just over a week and would appreciate anyhelp Lloyd :confused: Thanks for...