Normalisation help

[663scott]

Hi,

Please Please Pleas could someone just help me and tell me what I should do. No one seems to actually help me don't post any normalization links. I'll give you an example of the problem:

I have a very small online business which has an offer available to customers. The offer is only available to one member of a household and only once from the same IP address. I then want to search for a specific user name in the IP section to see if any other accounts have tried to go in for the offer. Then I can work out if I should give it to the customer or not.

I have attatched my setup for this database as a photo. I have entered User name 1-5 as separate fields which are linked to the IP in the customers details. However I will find it hard if I want to search for a particular username as I will need to search each field individually.


I would like to see if there was a different way that I could set up the database structure in order to:

1 search for a username easily only entering the information once (not five times)
2. Be able to put in an unlimited number of links into the table, allowing a report to display all the user names effectively

[MMcCarthy]

Hi,

Please Please Pleas could someone just help me and tell me what I should do. No one seems to actually help me don't post any normalization links. I'll give you an example of the problem:

I have a very small online business which has an offer available to customers. The offer is only available to one member of a household and only once from the same IP address. I then want to search for a specific user name in the IP section to see if any other accounts have tried to go in for the offer. Then I can work out if I should give it to the customer or not.

I have attatched my setup for this database as a photo. I have entered User name 1-5 as separate fields which are linked to the IP in the customers details. However I will find it hard if I want to search for a particular username as I will need to search each field individually.


I would like to see if there was a different way that I could set up the database structure in order to:

1 search for a username easily only entering the information once (not five times)
2. Be able to put in an unlimited number of links into the table, allowing a report to display all the user names effectively

Forget about Table2.

If you set properties for IPAddress field in Table1 to Indexed = Yes (No Duplicates) then you won't be able to enter the same IP address a second time. So if IPAddress is already in the database you won't be able to add it again.

Mary

[663scott]

Hi

Thanks for that. I understand that limitation, that is why I was hoping someone could help me how do I solve the issue ?

663scott

[MMcCarthy]

Hi

Thanks for that. I understand that limitation, that is why I was hoping someone could help me how do I solve the issue ?

663scott

Sorry Scott but I really don't understand the question you are asking.

[663scott]

no problem didn't think you would