Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lallous
Starting Member
12 Posts |
 Posted - 2006-01-26 : 12:55:09
|
| Sorry for spamming the forums but i've been trying for over an hour trying to fix this macro.I have two tables: customer and invoice (they are linked obviously by a relationship).I have 2 forms:one is called customer and the other is called invoice.I am creating my macro and here is what i have:under action:OpenFormForm Name: Invoice (since i want to open invoice when i click on customer)View:FormWhere Condition: [customer num]=[Forms]![invoice]![customer num]where customer num is the customer number in both tables.When i click on the Customer form it opens but for example if i open Customer 4 I dont see the respective invoice. All i see is 0 values in the invoice form.Is something wrong with my where condition? |
|
|
lallous
Starting Member
12 Posts |
Posted - 2006-01-26 : 13:03:25
|
| Wow I reached something now..Hopefully i got it right |
 |
|
|
|
|
|
Macro Help