If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
field dependent on another field
Can you create a field in a table that can only be filled out if another
field is filled out? For instance, you need to know how much somebody paid, but only if they have already paid. Otherwise, how much they paid should be left blank. Is there a way to do that? |
#2
|
|||
|
|||
field dependent on another field
Generally the logic is that if an amount of payment is entered a payment has
been made. There is no need for a field to indicate a payment has been made. Steve "felicitator72" wrote in message ... Can you create a field in a table that can only be filled out if another field is filled out? For instance, you need to know how much somebody paid, but only if they have already paid. Otherwise, how much they paid should be left blank. Is there a way to do that? |
#3
|
|||
|
|||
field dependent on another field
"How" depends on "what", as in "what is your data structure?" ...
Are you recording one record per payment? Or are you using a single field to show total paid so far (and updating it as new amounts are paid)? More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "felicitator72" wrote in message ... Can you create a field in a table that can only be filled out if another field is filled out? For instance, you need to know how much somebody paid, but only if they have already paid. Otherwise, how much they paid should be left blank. Is there a way to do that? |
Thread Tools | |
Display Modes | |
|
|