Ok, what I did was I added a new field (customer number) into the subfield table. I was trying to be able to search by it, but realized I could just use the one that was a foreign key in another table. But I was trying to it on my main form.
But just out of curiosity is there a way to do that? Like have an unbound text field that takes any data put into it and inputs it into a field?
Okay you lost me. This is the table structure you defined in the Auto Number Not Linking thread:
- Customer table Order Info table Order table
-
|Customer ID*|-------------|Customer ID | /--|Order Number|
-
|Name | |Order Number* |---/ |Item |
-
|Phone | |Payment Method | |Quantity |
-
|etc... | |ect... | |etc... |
-
-
-
where both *'s are primary keys, and auto numbers
Try explaining exactly what you're trying to do using the actual field names and table names (if this structure is irrelevant, please include the tables/queries that are). It's just easier to understand when you include all the info.
Are you saying that you added CustomerID to the Order Table?
And your question was whether or not a user can type something in, click a search button, and have the form pull up that information? (Not sure if I interpreted that right or not)