Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Lotus Approach Database.

Lotus Approach Database.

Lotus Approach Database.

Good Morning/Afternoon/Evening

Just a quick question guys, i know your the guru's at Lotus Approach,

My question is, i've made a small database contining 1500ish people. anyway i need this to be relational. and i cant find anywhere that i can make it relational. ive made join's between the databases. but when i do, it just makes another company when i add another customer.. i'm just STUCK :( I have been working on this for just over a week and dont know where to go from there.

is there any books i can buy or can i visit someone's website and get them to make it for me

Thanks in advanced


RE: Lotus Approach Database.

The key to adding records in your case is to make sure which database is the "main" database for your form. If it is the company database, a new record will be added to that database.

If you are adding people, the form should be based on people. You can assign them to a company record by selecting the value for the join field accordingly. For example, I would put the join field from people on the people-based form, and set it up as a "field box and list" with the source of the list being the company database's join field. If it is a number or other type of "cryptic ID", you could display the company name as the description to be displayed for the user to select. When the name is selected, the join field in people would fill in with the company's ID value.

You asked about books, and I would recommend any of the Approach books including those for version 3 or the 96-97 versions. I am the author of the best book on Approach 96, but it is out of print and only shows up on Amazon occasionatlly.

Most of us learned by "doing" or by looking at examples. One place you can do that is by creating applications from the supplied SmartMasters and examining how they work.

Sue Sloan

RE: Lotus Approach Database.

Thanks for your reply Sue, i'm now using File maker pro.



RE: Lotus Approach Database.

Sue since you are the author of the best book on approach and its out of print, how do we get the best book?  Will you do another best book?

RE: Lotus Approach Database.

Hello--I am looking for a Lotus Approach Programmer to tune-up my relational database. The vast majority of the work is already done.  Please contact me at matt.bars@prodigy.net
to discuss fees, etc.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close