Question Adding tables to a split database

[Jason1]

I am calling for a little help once again. I have recently spit my database I guess you would say successfully haha. I am trying to add another table to the database. I thought it would be straight forward, just open the backend database and add the table. The problem I came across is that I need one of the fields to be a lookup field from a query. With the database being split, the queries are on the front end, and the tables are on the backend. I'm sure there is a way to pull this off, but my rookie skills are lost once the wizard turns up blank.

any help is appreciated.

Jason

 

[gemma-the-husky]

really, the general recommendation is not to define lookups at table level. You can always do it by defining a query in the front end anyway. often the auto-lookup query isn't exactly what you want.

 

[CBrighton]

If it's a lookup then it's data in another table which you are saving more than once?

Why do you need to save the same data a second time in another table? Can't the front-end just perform the lookup in its queries based on the new table?

 

[Jason1]

Thanks Gemma. That being said I am going to try to describe my situation as best I can, and ask that you tell me how you would go about getting the records returned that I am looking for.

I have a table that has a batch number field, a waste units field, and a yes/no checkbox field for whether or not the batch has been processed, along with a couple other text fields.

All of these fields are filled in from a from called FRMskidentry except the checkbox, and the waste units fields. The batchnumber field is the primary key, and is generated automatically.

I want to fill in the waste units and processed checkbox from another form called FRMwoskidentry. I would like to have the batchnumber field in the form only show the batchnumbers that have not been processed (from a query), the waste units will be entered manually, and the checkbox will then be present to mark the batch as processed and thus remove it from the query results.

I hope this is not too hard to understand. Let me know your ideas.

Thanks,
Jason

 

[Jason1]

Cbritgton,

That makes total sense when you say it like that. I couldn't get the information I wanted from a query, but it was just me not setting things up right. I got it working now. Thanks for all the help

 

[Galaxiom]

BTW The backend doesn't really need to be opened to add a table.

Create the table in the front end, export it to the backend, delete the FE table and link the new backend table. I find the export more convenient than opening the backend database and the other steps are the same either way.