Please Help Me God! Fake SS#
Oct 23, 2006
I have a datbase that accepts the company's unique ID like a Social Security Number. My problem is when I put orders using another table, a person can put in the person's Company name but with the wrong ID Number.
Example:
Name: Peter
SS: 475-061-1111
Now I make an order with:
Name: Peter
SS: 475-061-1112
Even though peter is in the main table with the SS# as a primary, a person can still put in another SS#. I been dealing with this problem for about 2 weeks and can't find no solution. Can someone please help me fix this so I can just have this database up and running. I have two tables, one with the client's Name & Number
And
The other table which just takes jobs. I just want the dataentry form not to allow new numbers made up. Just use the numbers that is already there connected to the specific name. Someone out there please put me out of my misery with an example if you can......
View Replies
Jul 17, 2006
How can I create a fake autonumber in a query? I have a set of data that have their own individual number but I would like to sort them by date and then run a dsum() based on the FAKE autonumber.
-Alex
View 5 Replies
View Related
Jul 15, 2006
Hi Guys,
8 posts on the subject over a number of years and the answer seems to have been no, you can't have an auto number field in a maketable query.
Is there any reasonable way to create a sequential count of the records shown in the maketable query, not the underlying records?
Background:
I have a maketable query that selects fields from 2 tables which are ordered in a specific way. The sigma button is clicked to reduce this recordset to unique entries and this is what goes into the created table.
This newly created table is a row heading for a pivot table query and I want it ordered by the method used in the query. An autonumber or some method of counting/incrementing the records would do the trick.
I am currently creating the table and then adding the Autonumber field manually, which is hardly a solution at all. :confused:
An afterthought before I post: The reason I want the autonumber field is that the pivot table shows the records in alphabetical order rather than the order the table holds the records. Is there any way of forcing the pivot table to use the records as ordered in the table. A note of caution here, I get very confused when dabbling with pivot tables. :eek:
Any thoughts/solutions welcomed. And if I'm asking the wrong question, let me know! :)
View 3 Replies
View Related
