Search results

I don't see "Form Before"

Where would I enter this code? At the "On Click" property?

Is there any way to require data into a field at the FORM level and not in the table?

I thank you kindly for your response gemma, but I must ponder this whole project. I feel as though while I may not be entirely in over my head, the water is up to my neck :) I will try to use the information you provided. Thank you.

Hi all. I thought I had this problem resolved from previous posts, but as it turned out when I started adding data I found it didn't work. So, I went to an existing database template and modified it for our use. However, there are two things I can't do and I'm guessing it's in the structure...

Hi Folks - could someone please direct me to where I can get some understanding . . . On a form field I want to use the property event "after update" code builder. (Essentially I want to make a field "null" when I make an entry in another field.)

oops . . .not "After Update" but rather at "Current" (to requery)

To refresh the combo boxes - on the subform in the After Update property I selected Embedded Micro and selected Requery action; and entered both the lid and tote queries. I've attached the database in case it would be helpful to anyone else that's been following along.

I'll work on it. Thank you for all your help!!!

Is this looking right?

I see there that I did have a link between transactions and transactionscontainers; using id's. Perhaps I didn't do it correctly?

I'll make those table & relationship changes. How do I create a "drop down"? That's different than a "combo" field or "list" field right?

Is this looking right? I'm not getting how to make the form/subform work. (F_Transactions)

ok. i'll work on this.

i'm working on modifying those queries now - the "available" and "unavailable" queries; since we moved those fields to another table. And then I create that subform based on the "available totes" and "available lids" queries, right?

So does this look right?

I'm wondering if I even need the Transaction table . . . It would seem the T_TransactionContainers would be fulfill what I need?

I will work on this.

Essentially there will be one transaction (created by one employee, shipping to one customer) that includes many totes and many lids. We want to know which employee performed the transaction; to which customer it went; and which specific containers/totes and lids went to that customer.

the transactions table